The Dangers of Detach
I ran across a twitter conversation about a post recently. The post talks about detaching or attaching databases in bulk....
2013-09-18
1,094 reads
Blog Posts
#TribalSQL: A new book by new voices in SQL Server
Two years ago, we were talking about how cool it would be to get a bunch of unpublished authors to...
2013-09-17
525 reads
Brad Shultz’s blog on reviewing your database
This is possibly the best blog I have every read on the subject of reviewing a database. It is witty,...
2013-09-17
708 reads
Debugging database mail issues in your SQL Server with T-SQL
Problem. Your database mail suddenly stopped sending out email notifications on completed jobs and tasks. You try to send out...
2013-09-17
1,104 reads
Don't Rush When It Comes to Privacy Data
The Dataloss list sent the following article through yesterday afternoon:
Obamacare Employee Accidentally Sends Out 2,400 Social Security Numbers
This is concerning,...
2013-09-17
2,224 reads
Encryption Decryption Routine
In this post we will look at a complete end to end routine for encrypting, storing, decrypting data in SQL...
2013-09-17 (first published: 2013-09-11)
3,866 reads
Geometry in the Cloud - where geospatial data meets the cloud.
Mount Olympus: Stratosphere: It was inevitable that two innovative technologies would merge to create a world of potential in the...
2013-09-17
1,554 reads
Great Idea: Tribal SQL
Writing books, even just a chapter, is not easy. Yet, people are desperate to do it for some reason. But,...
2013-09-17
842 reads
Guide to SQL Server Table Indexes – (Part 4)
Checkout the part-4 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn...
2013-09-17
520 reads
Introduction to Integrity: Chain Linkage Problems
We’re approaching the end of our six part series Introduction to Integrity, sponsored by Idera with our last two postings...
2013-09-17
1,142 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers