SQL Server 2005 Diagnostic Information Queries (April 2010)
Since SQL Server 2008 R2 has gone RTM, and will soon be available for purchase, I am going to be...
2010-04-26
994 reads
Blog Posts
SQL Server 2008 R2 Books OnLine - available now...
SQL Server 2008 R2 is released on April 21st, 2010 and in parallel with this new release, now is available...
2010-04-26
2,931 reads
SQL University: Auditing SQL Server, Part I
Welcome to the Security and Auditing Week for SQL University. Last semester we looked at the basics of SQL Server...
2010-04-26
2,788 reads
SQLSaturday Sites Will be Offline For Part of April 27, 2010
We’re scheduled to begin moving web sites and data to PASS servers at 12:00 pm Eastern on April 27, 2010....
2010-04-26
491 reads
SQLSaturday Success! NYC #39, has left the building.....
Well, it’s Monday morning and back to the DBA salt mines!
Now that SQLSaturday #39 is all but a joyful...
2010-04-26
578 reads
SSIS : Conditional Split optimization
I have built an enormous number of packages for this project over the past few weeks (just over 60) and...
2010-04-26
559 reads
SSIS : Using the VariableDispenser object within Script Components
I have become accustom to modifying package variables within my Script Task using the VariablesDispenser object. It is convenient and powerful. I started working...
2010-04-26
3,096 reads
SSIS : Using the VariableDispenser object within Script Components
I have become accustom to modifying package variables within my Script Task using the VariablesDispenser object. It is convenient and powerful. I started working...
2010-04-26
1,565 reads
Upgrading your Beta/CTP Software
This is one of the reasons that I don’t like to put CTP software (or Beta software) onto machines that...
2010-04-26
1,160 reads
A DMV a Day – Day 25
The DMV for Day 25 is sys.dm_os_memory_cache_counters, which is described by BOL as:
Returns a snapshot of the health of a...
2010-04-25
1,699 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