PowerShell 2.0 on Windows XP SP3 - Can It Be Upgraded?
In my last blog post I indicated that I would be adding learning PowerShell to my list of goals. I...
2010-04-15
5,038 reads
Blog Posts
Schedule Published for SQLSaturday #38 in Jacksonville
SQLSaturday #38 is coming up on May 8th, 2010, back at the same location as in previous years at the...
2010-04-15
492 reads
SQL Saturday #38 Jacksonville Update
With less than a month away, May 8, before the big event in Jacksonville I wanted to give you a little inside...
2010-04-15
576 reads
SQL Server 2008 R2 – Release Date
This is a very short post
I’m probably very late to this party but…SQL Server 2008 R2 is scheduled for release...
2010-04-15
514 reads
SQL Server 2008 R2 Release Date: May 21 2010
R2 is ready to roll!
As expected, Brent “Master” Ozar (Blog | Twitter) already scooped the story, but it never hurts to...
2010-04-15
480 reads
Third Party Backup Tools – Redgate SQL Backup
To continue my little blog series on SQL Server backups, any series would not be complete without a look at...
2010-04-15
2,905 reads
A DMV a Day – Day 14
The DMV for Day 14 is sys.dm_os_wait_stats, which is described by BOL as:
Returns information about all the waits encountered by...
2010-04-14
788 reads
A Quick Queue Process
As SQLServerCentral grew, we evolved through a few email sending solutions to meet the demand. We started with a manual...
2010-04-14
783 reads
How Do I Kill All Sessions from a Windows Group?
Introduction
The stored procedure I am posting today will kill all sessions for users that are members of a given domain...
2010-04-14
514 reads
How to Avoid Some Common Developer and DBA Mistakes
In March, I ran a Question of the Month that asked, “What is the biggest mistake/problem you ever found on...
2010-04-14
2,815 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