Getting SQLServers Last Known Good DBCC Checkdb with PowerShell and dbatools
As good SQL Server DBA’s we want to ensure that our databases are regularly checked for consistency by running DBCC...
2017-04-05
647 reads
As good SQL Server DBA’s we want to ensure that our databases are regularly checked for consistency by running DBCC...
2017-04-05
647 reads
In a previous post I showed how easy it is to test your backups using Test-DbaLastBackup
Today I thought I would...
2017-04-05 (first published: 2017-03-22)
1,926 reads
If your server collation is different to your database collation then you may find that you get an error similar...
2017-04-03
659 reads
Whilst I was writing my Test-DbaLastBackup Posts I ran into a common error I get when importing datatables into a...
2017-04-01
1,604 reads
I read a great blog post about answering the question how big is the database using T-SQL on SQL Buffet...
2017-03-29
978 reads
All the good DBAs backup their databases.
A significant amount of SQL DBAs use Ola Hallengrens maintenance solution to do so.
This...
2017-03-29 (first published: 2017-03-18)
3,050 reads
I have written about Test-DbaLastBackup in posts here, here and here. They have been Windows only posts.
With SQL Server vNext...
2017-03-27
349 reads
In a previous post I wrote about how easy it was to restore a whole SQL Servers user databases from...
2017-03-20
1,001 reads
Just a quick post, as much as a reminder for me as anything, but also useful to those that attended...
2017-03-17 (first published: 2017-03-12)
2,687 reads
One of the most visited posts on my blog is nearly two and half years old now – Add User to...
2017-03-16 (first published: 2017-03-06)
1,729 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
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