Documenting the database is always a challenge, and there are many techniques you can use to help all the people on your team understand what all your tables are used for. David Poole brings us an easy way to implement a framework for documentation.
2014-04-25 (first published: 2011-02-17)
14,650 reads
Michael Sorens aims to make PowerShell a bit easier to get going with by providing a series of collections of general-purpose one-liners to cover most of what you'll need to get useful scripting done.
2014-04-25
6,795 reads
Have you received an XML file that must be migrated into a production database? Today’s workshop dives into an ad hoc method of processing relational datasets delivered in an XML file format.
2014-04-24
4,426 reads
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,204 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
311 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,899 reads
I’ve been thinking a lot lately about what it actually takes to make an...
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Comments posted to this topic are about the item Finish the quote
Comments posted to this topic are about the item Everything I Needed to Know...
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers