Search Stored Procedure Text
There will come a day, if it has not already come and gone, when you will want to search through...
2011-04-26
1,076 reads
Blog Posts
SQL Azure Diagnostic Tool
One of the CSS Engineers from Microsoft has released a diagnostic tool for SQL Azure. It’s worth a look. It’s...
2011-04-26
1,015 reads
SQL University: Who has access to my SQL Server?
Welcome to PowerShell Week #2 for SQL University! One of the frequent questions I hear is, "Who has access to...
2011-04-26
2,791 reads
Transforming SSIS' sysssislog Entries Into Something More Readable
The format of sysssislog in SSIS 2005 and 2008 isn't great for human consumption, so what follows is an attempt to reformat it for easier digestion. It isn't perfect...
2011-04-26
17 reads
Transforming SSIS' sysssislog Entries Into Something More Readable
The format of sysssislog in SSIS 2005 and 2008 isn't great for human consumption, so what follows is an attempt...
2011-04-26
1,947 reads
Transforming SSIS' sysssislog Entries Into Something More Readable
The format of sysssislog in SSIS 2005 and 2008 isn't great for human consumption, so what follows is an attempt to reformat it for easier digestion. It isn't perfect...
2011-04-26
6 reads
A Caution About Checkpoints
Checkpoints in SSIS are a great tool and they definitely have their place. The downside to them is that they...
2011-04-25
1,116 reads
A SQL Server Hardware Nugget A Day – Day 25
For Day 25 of this series, I want to talk about how you go about picking a CPU for your...
2011-04-25
547 reads
Disable SQL Agent Jobs with PowerShell
I had a need today to disable all of our admin jobs while I moved our admin database to another...
2011-04-25
2,835 reads
Do You Enable “Optimize for Ad Hoc Workloads”?
Most of the time when I run a poll on my blog, I run it for at least a month...
2011-04-25
2,489 reads
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers