Monitor Database Growth and Usage
Create a repository of all your database devices and stay informed about changes in their size and usage.
2014-12-04
11,287 reads
Articles
Bitwise Operations in T-SQL
How can you get a list of columns that have changed within a trigger in T-SQL? How can you see what bits are set within a varbinary or integer? How would you pass a bitmap parameter to a system stored procedure? Phil Factor has answers.
2014-12-03
11,287 reads
Runbooks in SQL Azure
SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud” enabling automation of time consuming, repetitive tasks.
2014-12-02
6,492 reads
Using Stored Procedures to Provide an Application’s Business-Logic Layer
When faced with a complex business application, Dwain's team chose to encapsulate and implement most of an application’s business logic in SQL Server, using an interface made up of stored procedures. Here's how they did it.
2014-12-01
9,228 reads
2014-11-28 (first published: 2012-12-06)
17,369 reads
Guidelines for Using Natively-Compiled Stored Procedures in SSIS Packages
As you may know, SQL Server In-Memory OLTP introduced in SQL Server 2014 offers great performance improvements for ETL processes. In this tip we cover techniques you need to know about various behaviors of SQL Server In-Memory OLTP depending on the options you select.
2014-11-28
8,026 reads
Templates and teamwork
SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.
2014-11-27 (first published: 2008-05-20)
10,306 reads
Explaining The SQL Server 2014 Analysis Services Data Mining Model Lift Chart
In this tip, Dallas Snider explains how to interpret the Lift Chart found on the Mining Accuracy tab of a SQL Server 2014 Analysis Services Data Mining structure.
2014-11-27
7,629 reads
2014-11-26
579 reads
SSIS 2012 Projects: Deployment Configurations and Monitoring
The Project Deployment Model introduced in SSIS 2012 speeds up the deployment of database projects in which there may be hundreds of SSIS packages per project. Not only that, but deployments can be configured differently for each environments such as test and staging, and there are now ways of monitoring the status and performance of packages and of versioning the SSIS Catalog.
2014-11-26
7,422 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers