Scheduling backups in SQL Server Express
I have seen many forum posts asking how do you schedule backups for SQL Express databases and the answers always...
2010-03-29
1,706 reads
Indexes - where you cannot create them!
Indexes are the objects that DBA uses them everyday and maintaining them very often, during the maintenance routines. The main...
2010-03-29
3,708 reads
Notes from the Orlando Code Camp March 2010
I arrived about 7:15 and already quite a few people on hand. Registration was moved to inside this time, just...
2010-03-29
973 reads
Using Custom Connection Colors in SSMS
One of the new features that was added to SQL Server Management Studio (SSMS) in SQL Server 2008, which was...
2010-03-29
3,992 reads
To Get Certified or Not Get Certified
I have noticed quite a bit of discussion recently about the merits of Microsoft certification. Some people (like me) think...
2010-03-29
932 reads
TempDB – Relocate the TempDB Database Files
I took control of a new server recently and noticed that Tempdb was not configured to best practice. It was...
2010-03-28
1,295 reads
DBCC INPUTBUFFER vs fn_get_sql
Someone asked a question in the forums the other day and I realized it would make a pretty decent blog...
2010-03-28
8,777 reads
Making Sense of Replication Errors in Replication Monitor
Making Sense of Replication Errors in Replication Monitor If you've ever had to deal with errors in Replication Monitor, your first...
2010-03-27
12,090 reads
SQL Server Social Group a Fresh Perspective on User Group Meetings
The Cam river flows through Cambridge, England. At the center of the river you can see a punt (a type...
2010-03-27
477 reads
So you want to write a blog?
First, figure out what you want to write about. It should be something you have passion for. And it should...
2010-03-27
1,537 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers