Conditional WHERE Clauses and Boolean Algebra
Utilize simple boolean algebra and nullable parameters to implement conditional WHERE clauses without dynamic SQL.
2010-08-31
18,011 reads
Articles
Streaming Profiler Data Through StreamInsight
Using the Trace Management objects API it is possible to capture the events happening on SQL Server or indeed Analysis Services. I got to thinking that this would be a good thing to stream out in real time in StreamInsight and do some analysis “In Flight”. So here is a short video of me doing just that.
2010-08-31
2,302 reads
Why is data integrity important?
Why should I care and why should the database enforce it? This article from Jamin VanderBerg gives some reasons why the database is the place to enforce rules that ensure integrity.
2010-08-30
4,024 reads
Memory
Not a sound from the pavement. Have you ever come across a SQL query that used to run faster? Has that...
2010-08-30
5,561 reads
Writing an SSBS App When the Initiator and Target are on the Same Database
SQL Server Service Broker (SSBS), introduced with SQL Server 2005 and enhanced in SQL Server 2008, allows you to write queuing/message based applications within the database itself. This article discusses creating an application in which Initiator and Target both are in the same database.
2010-08-30
2,117 reads
DBA Morning Check List
This article helps the DBA find and fix issues quickly by creating a DBA Morning Checklist.
2010-08-27 (first published: 2008-04-14)
59,351 reads
SQL Source Control - Q & A
After a webinar for SQL Source Control, there were a large number of questions left unanswered. All have been listed here, along with answers from the Red Gate development team.
2010-08-27
3,868 reads
Defensive Db Programming Chapter 05
We are here again with after another week and ready for another episode in this series. Today we get to...
2010-08-27
4,181 reads
SQL Schema Comparison with Visual Studio 2010
we normally do development on the development box; then during the build preparation we compare the development database with the QA/UAT/Production database to identify differences and generate schema objects for synchronization or incremental deployment scripts. How we can compare schema objects between databases and generate synchronization or incremental deployment scripts?
2010-08-27
4,519 reads
A deadlock was detected while trying to lock variables in SSIS
Error: 0xC001405C at SQL Log Status: A deadlock was detected while trying to lock variables "User::RowCount" for read/write access. A lock cannot be acquired after 16 attempts. The locks timed out. Have you ever considered variable locking when building your SSIS packages? I expect many people haven’t just because most of the time you never see an error like the one above. I’ll try and explain a few key concepts about variable locking and hopefully you never will see that error
2010-08-26
3,320 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