Where is my Availability Group?
In SQL Server 2012 we got this great new high availability feature called availability groups. With readable secondaries under the...
2014-03-21 (first published: 2014-03-18)
2,975 reads
Finding Mistakes
Ever had that moment where you start getting errors from code that you’ve tested a million times? I had that...
2014-03-18
782 reads
Reminder: Orlando Code Camp Is This Weekend (March 22, 2014) and It’s Not Just For Developers!
I’ll be attending the Orlando Code Camp this weekend. I know it says “code”, but there is a SQL Server...
2014-03-18
529 reads
A Minute About Minute Key
You may have seen these minuteKey boxes at your local home supply store (Lowes has it near me) that let...
2014-03-18
732 reads
Performance improvements in SQL Server 2014
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-18
1,268 reads
DBAs should be on CLOUD 9 - IT Trends
For all the talk and initial fear that the DBA is going the way of the Dodo (pronounced doh-doh) (an...
2014-03-18
2,103 reads
Remaining Vigilant, my contribution to #DBAJumpStart – Part 1
This post is part of the SQL Community Project #DBAJumpStart by John Sansom.
“If you could give a DBA just one...
2014-03-18
770 reads
A New Day at #Ntirety
We - the rank-and-file employees at Ntirety - received word yesterday that we had been acquired by Hosting, a cloud and network...
2014-03-18
591 reads
Webcast – Small Changes Can Make a World of Difference
This Thursday, 10AM GMT, I will be hosted by Dell’s Richard Douglas (blog|twitter) for a webcast. I will present my...
2014-03-18
453 reads
PowerShell – System Information
Different ways to find system information are given below:-
Method 1:Querying WMI objectsDownload the code SystemInfoCreate the function with Powershell console...
2014-03-17
658 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers