SQL Server Haunt 2017
Halloween is a great time of year. It is unfortunate that it is just one day of the year. That...
2017-11-01
454 reads
Blog Posts
SQL Server on Linux Online Training with Brent Ozar Unlimited!
I’m proud to announce to you that I’m partnering with the folks over a Brent Ozar Unlimited to provide live,...
2017-11-01
499 reads
When is it a good idea to consolidate multiple instances?
In this age of cost-saving after cost-saving, one way you may be looking at saving money is by combining multiple...
2017-11-01 (first published: 2017-10-23)
2,117 reads
Windows Tips and Tricks – Why do I Have Trouble Ejecting USB Hard Drives?
External USB drives should be safely detached from Windows instead of just unplugging them from the computer. Most of us...
2017-11-01
391 reads
All New Collations in SQL Server 2017 Implicitly Support Supplementary Characters
As I was testing whether or not the new “Variation Selector Sensitive” ( _VSS ) Collations in SQL Server 2017 would assist...
2017-10-31 (first published: 2017-10-16)
2,623 reads
Azure SQL Database Managed Instance
Azure SQL Database Managed Instance is a new flavor of Azure SQL Database that is a game changer. It offers...
2017-10-31
1,186 reads
Book from a library. Learning never stops for data professionals.
[2017-Oct-31] If you have never read the "Iacocca: An Autobiography" book by Lee Iacocca, I highly recommend it. I read it...
2017-10-31
621 reads
SQL Server 2017: Making Backups Great Again!
In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database administrators. While SQL Server 2017 added so many great...
2017-10-31
56 reads
The Quickest Way To Get SQL Command Help
Every once in a while I discover a SQL Server Management Studio trick that's apparently been around forever but is completely new to me.
Today I want to point out...
2017-10-31
15 reads
The Quickest Way To Get SQL Command Help
Formula One …. F1 …. Photo by Jp Valery on UnsplashEvery once in a while I discover a SQL Server Management Studio trick that’s apparently...
2017-10-31
397 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