There is a stored procedure that must be run by only one user at a time. In this tip, learn how to prevent multiple users from running the stored procedure at the same time.
2014-04-24
6,094 reads
The task of Database Normalization doesn't have to be painful, especially if you follow Old Mother Celko's Normalization Heuristics.
2014-04-23
6,652 reads
Marcin Policht reviews security related challenges of Microsoft Azure Software as a Service-based SQL Database, focusing in particular on the SQL Server and database-level firewall access control functionality and methods that can be employed to implement it.
2014-04-22
3,521 reads
This article describes a way to automatically restore multiple database backups from a directory.
2014-04-21
6,191 reads
Simple-Talk sat down with David Bick, a Red Gate Product Manager, to discuss his work on SQL Monitor and why passively monitoring SQL Server just doesn’t cut it anymore.
2014-04-21
4,290 reads
Please join us on Saturday, May 3rd, 2014, as both business analysts and IT professionals come to learn and network with experts for the first SQLSaturday Business Analytics edition. Please register while space is available
2014-04-18
305 reads
Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.
2014-04-18 (first published: 2011-01-11)
13,878 reads
This beginner's guide to Wait Stats by Jonathan Kehayias and Erin Stellato is a free PDF download brought to you by SQL Skills and Simple-Talk.
2014-04-18
5,338 reads
An introduction to the XML Schema Collection and XML validation.
2014-04-17
19,412 reads
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers for participants.
2014-04-17
2,901 reads
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
Comments posted to this topic are about the item How Well Does the MSSQL...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers