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,789 reads
Blog Posts
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
4 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
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,113 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
544 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,834 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,488 reads
Enjoy Your Life
A sad weekend, and shocking news Sunday morning. I was out running errands when I checked email and found out...
2011-04-25
1,589 reads
Powershell Day 25
Day 25 RMO I have observed that no body has written anything about RMO. And replications is one of my...
2011-04-25
393 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