Quick MCM Prep Help
Before I went on vacation, I mentioned I was downloading some of the MCM videos from Technet.I had grabbed 4...
2010-12-31
1,622 reads
Blog Posts
The Year of Change: 2010 In Review
Like clockwork, another year has come and (almost) gone. It’s been a wild year on many fronts: major happenings included...
2010-12-31
1,592 reads
Windows Cluster Scripting with WMI and PowerShell
Windows 2008 R2 includes a failoverclusters PowerShell module, but you’ll probably find normal usage limiting for several reasons:
Only works on...
2010-12-31
3,675 reads
XQuery for the Non-Expert – Substring() Function
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Within the...
2010-12-31
1,775 reads
2010 PASS Summit Interviews
It’s entirely fair to say that the highlight of my professional year is the PASS Summit in Seattle, and the...
2010-12-30
1,796 reads
Can You Dig It? – StmtSimple Element
She can dig it!
D Sharon PruittWe’re up to the seventh post on the in the plan cache series. This time...
2010-12-30
1,977 reads
Looking Back at 2010
I’m writing this the day before Xmas, trying to finish up a bunch of odd tasks before the holiday weekend...
2010-12-30
1,448 reads
MCM Prep - VLF Allocations
I had heard that you could have too many VLFs in your transaction log, and it could cause performance issues....
2010-12-30
1,937 reads
Reviewing My 2010 Goals
You can go over my goals here. I’ve really hesitated to do this post because, in my opinion, I did so poorly. Here’s what I did: Community ...
2010-12-30
6 reads
Reviewing My 2010 Goals
You can go over my goals here. I’ve really hesitated to do this post because, in my opinion, I did...
2010-12-30
1,426 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