Additional Articles

Finding a table name from a page ID

by Additional Articles

SQLskills

Table Name

Imagine you come to work in the morning and notice that some new rows have been entered into the msdb.dbo.suspect_pages table during the night. Usually the first thing you’re going to do is run DBCC CHECKDB, but if your database is a few TB, that could be several hours before you know where the problem is, and which table may have lost data. You want to find out which table is involved as soon as possible so you can explore your disaster recovery options.

2014-10-22

9,484 reads

Exploring Your SQL Server Databases with T-SQL

by Additional Articles

SimpleTalk

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

Starting as a SQL Server Business Intelligence Developer

by Additional Articles

MSSQLTips.com

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

by Additional Articles

MSSQLTips.com

Foreign Keys (FK)

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

by Additional Articles

SimpleTalk

constraints

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

by Additional Articles

Redgate

Monitoring

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

by Additional Articles

MSSQLTips.com

Azure SQL database

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

by Additional Articles

Redgate

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

by Additional Articles

SimpleTalk

Primary Key (PK)

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