A Microsoft SQL Server community of 1,786,687 DBAs, developers and SQL Server users

Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.  Read more...

After finding it difficult to find seriously useful information on Azure blob storage written after Storage Client Library 1.7 (and we’re on 4.something now), Robin Shahan decided to try and fill that gap with this article.  Read more...

In the chapter 18-22 we explained how to work with Microsoft Excel to Access to the Data Mining information. This time, we will explain how to work with Microsoft Visio.   Read more...

There are different techniques to optimize the performance of SQL Server queries but wouldn’t it be great if we had some recommendations before we started planning or optimizing queries so that we didn’t have to start from the scratch every time? This is where you can use the Database Engine Tuning Advisor utility to get recommendations based on your workload.  Read more...

One of the main purposes of placing a database under source control, alongside the application code, is to allow team collaboration during development projects. The Version Control System (VCS) stores and manages all of the project files, maintaining an audit trail of what changed, and who made the change. Each team member can work on a file, or set of files, and submit their changes to the VCS to make them available to other team members. They can also inspect the VCS to discover recent changes made by other team members.  Read more...

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...

Tony Davis answers 10 surprisingly tricky questions about SQL Server Transaction Log.  Read more...

How do you make data available to analysts who want to blend data with R or Power Query tools? Why with OData services.  Read more...

One of the most important SQL Server DBA tasks is checking logical hard drive details such as the total capacity, free disk space, and used space by the SQL Server data and log files. In this tip we look at a method to view this information in a faster and simpler way.  Read more...

Learn how to do SQL Server continuous integration at the first in a new series of Database Lifecycle Management Training Workshops, in Silicon Valley on March 27. To celebrate the launch, places for this workshop are free.   Read more...

Check out this DevOps Reactions animated GIF and caption. It’s funny on multiple levels, but it also makes me both mad...  Read more...

There are many different ways to accomplish this tasks. Download Link https://gallery.technet.microsoft.com/T-SQL-How-to-Search-String-a1704fc6 The below examples uses undocumented sp’s to loop through all the...  Read more...