SQLSaturday #32 – Tampa
Just a reminder that SQLSaturday #32 – Tampa is taking place this weekend (January 23rd). This will be my 5th SQLSaturday...
2010-01-21
338 reads
SQL Server 2008 - Top Reasons to Upgrade.....
OK, you've seen many of these before, but if you haven't figured out its TIME to upgrade your SQL Servers to...
2010-01-21
1,216 reads
Andy on Twitter
Just prior to the 2009 PASS Summit I posted about giving Twitter a try, and thought I’d report back on...
2010-01-21
2,197 reads
Using sp_ExecuteSql to Run Dynamic SQL
Introduction
Lately it seems like I am being bombarded by Dynamic SQL and people who insist it is the only way...
2010-01-21
652 reads
Creating the SSC Maintenance Plan: Part 3
Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...
2010-01-21
1,763 reads
Part 3: Creating the SSC Maintenance Plan
Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...
2010-01-21
995 reads
PayPeriod Matching
Recently I was asked to alter a report to pull different more meaningful data. The particular report was pulling data...
2010-01-21
1,012 reads
SQL Server 2008 R2 - official date
Since the August 2009 when the CTP ( Community Technology Preview) version was available, the Microsoft announced the offical release date...
2010-01-21
449 reads
Setting a Dedicated Login To Run DMV Queries in SQL Server 2005\2008
In order to run server scoped DMV queries, you must have VIEW SERVER STATE permission for the login you are...
2010-01-20
921 reads
SQL Server Resource Governor
I didn’t know this bit Resource Governor in SQL Server 2008 is only available in Enterprise edition
2010-01-20
1,093 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers