SQL Azure
If you’ve talked to anyone from Microsoft recently you had to have heard the phrase “all in.” It’s been made...
2011-04-15
645 reads
Blog Posts
The Pro-Active DBA List Updated
A couple of years back, in the heart of the economic tsunami, I proposed a list of pro-active steps to...
2011-04-15
1,376 reads
A SQL Server Hardware Nugget A Day – Day 14
Since 2006, Intel has adopted a Tick-Tock strategy for developing and releasing new processor models. Every two years, they introduce...
2011-04-14
603 reads
Be the Master of your Data Warehouse Universe at SQLRally!
Do you have a data warehouse initiative in your current organization and looking for a way to learn how to...
2011-04-14
849 reads
Confessions of a DBA – Part 3
After reading this confession, I am sure almost every DBA is going feel a churn in their stomach. They are...
2011-04-14
2,052 reads
Get all SERVERPROPERTY values for SQL Server
A quick script to grab all the SERVERPROPERTY() values from a SQL instance in a table. Useful when you forget...
2011-04-14
13,447 reads
Optimising SQL Server for Sharepoint 2010
I attended the SharePoint Best Practices Conference this week in London. As a complete newbie, this event was superb - a...
2011-04-14
1,879 reads
Performance Tuning: Start to Finish
The very first ever SQL Rally is taking place in a little less than four weeks in Orlando Florida. It’s...
2011-04-14
1,348 reads
Powershell Day 14
Day 14 Tools and more info As Powershell is a global language and its open to explore. So many great...
2011-04-14
568 reads
Re-Blogging Posts
Over the last couple months, I’ve been trying to figure out what to do with some of my old posts. ...
2011-04-14
455 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