Exploring Your SQL Server Databases with T-SQL
Scott Swanberg shares 38 scripts he uses time and time again for discovering more about database objects.
2014-10-21
11,293 reads
Additional Articles
Starting as a SQL Server Business Intelligence Developer
Besides the technical skills required to be a proficient SQL Server business intelligence developer, there are numerous "soft" skills that can contribute to your success.
2014-10-20
9,505 reads
Drop and Re-Create All Foreign Key Constraints in SQL Server
Aaron Bertrand supplies a script which generates two separate sets of commands: one to drop all foreign key constraints, and one to create them again. These scripts are stored in a table so that, if you drop the constraints and then disaster of some kind strikes during the create, you still have everything handy and can troubleshoot if needed.
2014-10-17
8,457 reads
Set-based Constraint Violation Reporting in SQL Server
When you're importing data into an RDBMS in bulk and an exception condition is raised because of a constraint violation, you generally need to fix the problem with the data and try again. The error won't tell you which rows are causing the violation. What if you've thousands of rows to search when it happens? There are solutions, writes William Sisson.
2014-10-16
8,821 reads
The 3AM Meltdown - New DBA Team Article
Where do you start fixing a SQL Server crash when there isn’t a single clue? The DBA Team had better find out quick, or they’re not going to get any sleep tonight. Find out how it all goes.
2014-10-16
9,976 reads
Performing Azure SQL Database Management Tasks by Using PowerShell with REST API
Recently, we have been exploring the ability to administer Azure SQL Database by leveraging REST APIs invoked from PowerShell-based scripts. Such an approach offers more flexibility, facilitating functionality that is not directly exposed in the PowerShell cmdlets. In this article Marcin Policht shows the benefits when dealing directly with Azure SQL Databases.
2014-10-15
7,612 reads
Database Deployment Problems Survey
Red Gate is looking to build tools and features to help reduce the risk of database deployment. In order to achieve this, we need to get a better understanding of the most common deployment problems you are encountering when moving changes from development to production. Please help by filling in our two-page survey.
2014-10-14
7,457 reads
Questions about Primary and Foreign Keys You Were Too Shy to Ask
It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes to ask vital questions about SQL Server primary keys and foreign keys. Fear not, here are 13 questions you were too shy to ask, answered.
2014-10-14
9,933 reads
Understanding How to Use the UPDATE Statement to Change Your Data
Greg Larsen shows you a number of different ways to use the UPDATE statement to modify the data in your SQL Server tables.
2014-10-13
10,280 reads
Compare SQL Server Performance of In-Memory vs Disk Tables
With the release of SQL Server 2014 there came a lot of new features, including “In-Memory OLTP”. One would assume that storing a table in memory would most definitely be faster than using the conventional disk-based table storage engine. But just how much faster is it?
2014-10-10
8,756 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers