Blogs

29 July 2016

Ten Years Later

It’s hard to believe, but Simple Talk has now been going for over ten years. Thanks to brilliant pieces from our writers, hard work from the team here, and countless valuable contributions from you, our readers, we’re currently receiving one million page views a month, and sitting on a hefty 2,500 articles from over 370 … Read more
13 July 2016

Azure SQL Data Warehouse Lives!

Frequently when a new piece of tech that I’m excited about is launched, total nerd that I am, I’ll start quoting Colin Clive in, still the best, James Wale’s Frankenstein. It’s ALIVE! ALIVE! Well, time to get excited. On Monday, July 11, Azure SQL Data Warehouse moves from being in preview on Azure to a … Read more
30 June 2016

Invoke-SqlCmd Just Got Better!

If you’ve read even just a few of my articles on Simple-Talk you know that I’m a big fan of PowerShell + SQL Server.  Over the years I have written a lot about how to collect data from your SQL Servers and store it somewhere, maybe in a database, maybe in a word document.  Well … Read more
30 June 2016

Data Security: Time to be Grown-Up

How do you quickly clear a room-full of application developers, short of shouting ‘fire’ and setting off a smoke-bomb? The answer, of course, is to stand up in front of them and announce that you are giving a talk about database access-control and security. Once, at a conference, I sat through a brilliant talk on … Read more
15 June 2016

Measure of a DBA

Marketing people are often surprised when a new version of SQL Server doesn’t quite generate the atmosphere of excited anticipation that they expected. After all, people seem to get themselves in a state of frenzy when a new iPhone is introduced, and suddenly their present phone looks like a museum item. The urge to upgrade … Read more
06 June 2016

Unmasking the Dynamic Data Masking

/* Revised 27th June Dynamic data masking is a great product and solves some niche problems that come if you need to do certain testing with live data at the application level. You should, however, beware of using it as a database-level security device. I haven’t yet used it in testing because I don’t have … Read more
03 June 2016

Over-SQL-Engineering

In a recent blog post, Jonathan Kehayias demonstrates a clever way to “multi-thread” maintenance tasks, when they need to run against very large (i.e. multiple terabyte) databases. The tool he used? Good old-fashioned Service Broker. Simply create some basic Service Broker objects, an activation procedure to automate Ola Hallengren’s maintenance procedures, bind the activation procedure … Read more
02 June 2016

How to rename a table without data loss in SQL Server Management Studio using migration scripts

SQL Source Control plugs into SSMS and connects your databases to your version control system, allowing you to version control your database schemas, and then deploy them using Redgate’s trusted comparison engine SQL Compare. The latest release (shipped this week!) features an improved version of migration scripts, which allow you to write your own SQL … Read more
02 June 2016

SQL Source Control 5 – we’ve solved the data problem

We’ve just released SQL Source Control 5 with improved migration scripts. With this release SQL Source Control now brings modern development practices (think Git and branching) together with preserving data as changes move up environments. Finally, it really is possible to automate database delivery – so I hope you’ll forgive us if we sound overexcited! … Read more
23 May 2016

Identifying client timeouts

Long running queries often causes client timeout in our applications. One good solution to attack this problem is to identify the timeouts and optimize the queries causing the timeouts. Client timeouts or connection interruptions are identified as Attention events. We can capture the attention events using an Extended Events session. The script to create the … Read more
20 May 2016

SSMS Renaissance

For many good reasons, DBAs and database developers use SQL Server Management Studio (SSMS), not SQL Server Data Tools (SSDT). It is a great relief for them, after several SQL Server releases-worth of general neglect, to see some renewed developmental vigor behind SSMS. Until the approach of SQL Server 2016, DBAs could have been forgiven … Read more
11 May 2016

Quick Tip – Changing the SQLSERVER: location after import SQLPS module

You probably already must have realized when you import the SQLPS module the current location will be the SQL Server Provider :   If you want to change it and after imported it not keeps in the SQL Server Provider, just open the C:\Program Files (x86)\Microsoft SQL Server\XXX\Tools\PowerShell\Modules\SQLPS\SqlPsPostScript.PS1 and add the line Set-Location c: Set-Location SQLSERVER: … Read more
09 May 2016

How to identify contention in TempDb

TempDb database is used to store all temp tables created for our applications. Whether explicit or implicit created, all temp tables activity is done in tempdb, creating a bottleneck. For this reason, it’s important to identify tempdb contention. Tempdb contention will appear in the form of latches. Latch is a synchronization object that protects internal … Read more

Join Simple Talk

Join over 200,000 Microsoft professionals, and get full, free access to technical articles, our twice-monthly Simple Talk newsletter, and free SQL tools.

Sign up