SQLServerCentral.com Articles tagged Database Weeklyhttp://www.sqlservercentral.com/Articles tagged Database Weekly posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)The Technology Journey to DisasterPhil Factor on a journey that started with a decision to introduce a new IT platform, and ended in a disaster that left TSB customers locked out of their accounts, experiencing problems such as zero balances, incorrect currencies, and massively inflated mortgage amounts.]]>http://www.sqlservercentral.com/articles/Editorial/172112/Mon, 07 May 2018 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/172112/Taking ShortcutsWe don't mean to introduce security issues, but sometimes we do because we give in to pressure.]]>http://www.sqlservercentral.com/articles/Editorial/171817/Mon, 30 Apr 2018 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/171817/Desperation on the ForumsGrant talks about the challenges of helping people in online forums and getting them to learn rather than grab the first solution.]]>http://www.sqlservercentral.com/articles/Editorial/171219/Mon, 16 Apr 2018 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/171219/Stumbling over WordsPhil Factor argues that the ability to write simply and expressively is a much under-valued skill in IT, and explains the main traps to avoid.

How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.

]]>http://www.sqlservercentral.com/articles/Editorial/170678/Mon, 09 Apr 2018 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/170678/A New SQL Server EditionA new edition of SQL Server came out this week from Microsoft.]]>http://www.sqlservercentral.com/articles/Editorial/169774/Mon, 19 Mar 2018 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/169774/Troublesome NamesBuilding a name-and-address database sounds a disarmingly simple task, but if your name happens to be D'Arcy Join, then you probably know, from painful experience, that most programmers don't get it right. ]]>http://www.sqlservercentral.com/articles/Editorial/169460/Mon, 12 Mar 2018 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/169460/Abolish Disjointed TimeThe European Parliment is considering getting rid of daylight savings time.]]>http://www.sqlservercentral.com/articles/Editorial/168437/Thu, 08 Mar 2018 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/168437/Opportunity or Restriction?There is opportunity in complying with the new GDPR regulations.

How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.

]]>http://www.sqlservercentral.com/articles/Editorial/169155/Mon, 05 Mar 2018 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/169155/Building CultureThe origins of PASS have shaped its culture for years. Are you doing the same in your organization?]]>http://www.sqlservercentral.com/articles/Editorial/168596/Mon, 19 Feb 2018 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/168596/Database TamingSometimes a database can seem to be as willful as a colt. Taming it requires an iron nerve, and unflinching eye contact. Occasionally though, you need to know when to jump the fence and regroup.]]>http://www.sqlservercentral.com/articles/Editorial/168296/Mon, 12 Feb 2018 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/168296/We Do Need To UpgradeSecurity issues in older systems are going to be a problem.]]>http://www.sqlservercentral.com/articles/Editorial/167946/Mon, 05 Feb 2018 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/167946/How do the Experts Become Experts?How does one become better at some endeavor?]]>http://www.sqlservercentral.com/articles/Editorials/167747/Mon, 29 Jan 2018 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorials/167747/Data-driven PrototypesPhil Factor on a tale of how dodgy mock data derailed an otherwise-convincing prototype.

How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.

]]>http://www.sqlservercentral.com/articles/Editorial/167144/Mon, 15 Jan 2018 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/167144/Sizing New ServersSteve Jones talks hardware, which he mostly doesn't worry about for SQL Servers.]]>http://www.sqlservercentral.com/articles/Editorial/166573/Mon, 01 Jan 2018 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/166573/Understanding Your ValueFill out the 2017 salary survey to help us all understand where our compensation might lie relative to others.]]>http://www.sqlservercentral.com/articles/Editorial/165930/Mon, 18 Dec 2017 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/165930/Sharing DataThis week Steve discusses the security aspects of sharing data.]]>http://www.sqlservercentral.com/articles/Editorial/165759/Mon, 11 Dec 2017 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/165759/The Appearance of the Flat File Wizard.After many barren years, Phil Factor is pleased to see the first signs of Spring in SSMS.]]>http://www.sqlservercentral.com/articles/Editorial/165429/Mon, 04 Dec 2017 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/165429/A well-earned break from the databaseDatabases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.

How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.

]]>http://www.sqlservercentral.com/articles/Editorial/165116/Mon, 27 Nov 2017 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/165116/We Really Need Better SecuritySome disturbing security issues reported this week.]]>http://www.sqlservercentral.com/articles/Editorial/164839/Mon, 20 Nov 2017 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/164839/Microservices in SQL ServerIn SQL Server 2017 consuming or providing JSON data is so efficient that you can implement effective microservices right from the database, argues Phil Factor. ]]>http://www.sqlservercentral.com/articles/Editorial/164564/Mon, 13 Nov 2017 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/164564/The Importance of Clear Data DisplaysAn accident on a ship is being blamed on unclear data visualization.]]>http://www.sqlservercentral.com/articles/Editorial/164309/Mon, 06 Nov 2017 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/164309/Perspective]]>http://www.sqlservercentral.com/articles/Editorial/163980/Mon, 30 Oct 2017 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/163980/Tell the Judge You Have No BackupThe NYPD is claiming there isn't a backup for one of their databases.]]>http://www.sqlservercentral.com/articles/Editorial/163731/Mon, 23 Oct 2017 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/163731/Timing is EverythingPhil Factor on the wise habit of timing your database routines, to avoid relying on received wisdom about performance.]]>http://www.sqlservercentral.com/articles/Editorial/163474/Mon, 16 Oct 2017 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/163474/The Achilles HeelIn a long career in IT, Phil Factor cannot recall a 'major incident', where the failure or breach was due to a single 'Achilles Heel', or even a single team of people. They are always due to a whole plethora of slack and ignorant practices.]]>http://www.sqlservercentral.com/articles/Editorial/163199/Mon, 09 Oct 2017 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/163199/The Worms-eye ViewEven the most elaborate team-based development methodology won't compensate for the blinkered attitudes and tribal cultures that come from over-specialization in IT.]]>http://www.sqlservercentral.com/articles/Editorial/162909/Mon, 02 Oct 2017 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/162909/A SQL Server Bug and Data SecurityA bug in SQL Server needs patching right away if you use TDE. Some data security issues concern Steve as well.

How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.

]]>http://www.sqlservercentral.com/articles/Editorial/162529/Mon, 25 Sep 2017 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/162529/Avoiding the Hell of having to Remember DDL syntaxWhat's your favorite productivity tool when writing SQL? Phil Factor has has flirted with most of them, from templates and snippets to a programmer's clipboard and back again.]]>http://www.sqlservercentral.com/articles/Editorial/162287/Mon, 18 Sep 2017 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/162287/The struggle to renormalize dataYou are given an export of a NoSQL database, in JSON, and asked to import it into a relational database. Sounds easy? It isn't and Phil Factor explain why.]]>http://www.sqlservercentral.com/articles/Editorial/162016/Mon, 11 Sep 2017 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/162016/SQL Server in Space - HASSPA successful launch, and recovery, of SQL Server running below a balloon.]]>http://www.sqlservercentral.com/articles/Editorial/161684/Mon, 04 Sep 2017 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/161684/