Recovering the tail end of the transaction log
Knowing a great deal about backup and recovery is key to any DBA’s career. Most of us fully understand the...
2013-10-02
1,294 reads
Blog Posts
Setting Up a Domain Controller with PowerShell
Quickly setting up a domain controller is a vital step in creating a good demo environment. This post will walk...
2013-10-02
2,031 reads
SharePoint Reporting Services Content Types Missing
Being able to manage the content types in your SharePoint libraries is key to creating a useful portal. Among the...
2013-10-02
2,817 reads
Social Engineering: How to prevent unauthorized access to SQL Server using SQL Logins
People are always concerned about Security when it comes to their data. I don’t blame them, I love keeping my...
2013-10-02
727 reads
SQL Server – How to Copy or Export an SSIS Package Using Command Prompt Utility – DTUTIL
The command prompt utility dtutil can be very handy when we want to quickly export an SSIS package from either file system...
2013-10-02
1,484 reads
Using A Non-correlated Subquery To Avoid DISTINCT
Nobody wants duplicate data. It’s messy, wastes space, and looks really bad on a report – I get that. What I...
2013-10-02
1,320 reads
Why I am not an MVP
On October 1st the emails went out notifying existing MVP’s in the Oct cycle if they were fortunate enough to...
2013-10-02
762 reads
Awarded Microsoft MVP
Today I’m extremely excited, honored and humbled to announce that I have been recognized as a Microsoft MVP for first...
2013-10-01
695 reads
Detaching a database
In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL...
2013-10-01 (first published: 2013-09-26)
1,660 reads
Enable Instant File Initialization to accelerate database restore
Today my colleague come to me and ask me why her database restore query was hang. She was going to...
2013-10-01
1,244 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