Some Statement Start Times!
I thought I had captured statement start times within the DMV sys.dm_exec_sessions. I was absolutely wrong. However, this has sparked...
2009-08-11
955 reads
Blog Posts
The Joy of Data Modelling.
You may think that the task of teasing out the exact nature
of the data and processes within a company...
2009-08-11
2,494 reads
24 Hours of PASS
Rick Heiges has put together an interesting event coming up on Sep 2, 2009 called 24 Hours of PASS. As...
2009-08-10
835 reads
Adding Multiple Columns to a Table With a Single T-SQL Statement
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
2009-08-10
81,996 reads
Good News for IT professionals? - Ray of Economic Light Shines in July........
Here's some upbeat info to share as the week kicks off to a new start!
Data just recently released by the Department of...
2009-08-10
690 reads
Interview on SQLAuthority.com
Well-known Indian SQL MVP Pinal Dave has posted a short interview he did with me recently. Pinal is the founder...
2009-08-10
562 reads
Journey to trouble-shoot Error 5042 (cannot remove a file xxx because it is not empty)
I was working on a table partition management task yesterday. The table is partitioned on a datetime column, and each...
2009-08-10
8,938 reads
Networking for Your Career
It's hard to actually put a specific value on networking, and I've been skeptical of it in the past. However...
2009-08-10
1,197 reads
Notes on SQLSaturday #16
I went down to Miramar Fri morning, taking the loooong drive from Sarasota across Alligator Alley on I-75. Miles of...
2009-08-10
487 reads
Social Networking: Where Do I Start?
In a blog post a few weeks ago, I wrote about social networking in the SQL Server community. I was...
2009-08-10
1,000 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