SQL Saturday 89 Pre-Con
Why am I attending Kevin Kline’s pre-con on “Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2” at SQL Saturday #89...
2011-07-14
615 reads
Blog Posts
SQL Server 2008 R2 Service Pack 1 Released
Microsoft has released the final build of SQL Server 2008 R2 SP1. It includes fixes from SQL Server 2008 R2 RTM Cumulative Updates 1 through...
2011-07-14
1,352 reads
Backup and Restore SharePoint 2010 Site Collection with PowerShell
One of the most annoying processes with SharePoint is backing up a site collection. There is a build in tool...
2011-07-13
1,884 reads
Bad Admins: Attacking via Group Membership
This is a series of blog posts about how administrators can gain access to SQL Server, even if you try...
2011-07-13
1,875 reads
BI Documenter: Impact Analysis and Object Lineage
Are you considering making a change to your view or stored procedure? Or possibly you are considering moving your database...
2011-07-13
2,680 reads
Denali on TechNet Radio
A quick plug for my friend Blain Barton from Microsoft, he’s got a series of three broadcasts that are video,...
2011-07-13
740 reads
Do you use T-SQL debugging?
T-SQL debugging is not 100% in SQL Server. It has few bad drawbacks starting from difficulties when setting it up...
2011-07-13
1,218 reads
How to move the MSDB database
First we need to know the name and file location of the MSDB database files. When you change the location, make...
2011-07-13
958 reads
Make It Simple With Policy-Based Management
At work recently, I explained to a coworker the reasons and benefits of having databases in Simple mode in your...
2011-07-13
957 reads
Simple Database User-Access Security Validation & Granting Elevated Access Temporarily Using the Execute As Statement
If you ever want to validate what level of access a user has within a database OR wish to temporarily...
2011-07-13
1,125 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