The SQL Scrabble Puzzle
An enhancement to a Phil Factor puzzle gives you a chance to play scrabble in T-SQL.
2014-12-05
8,421 reads
Articles
Webinar: Performance Tuning .NET & SQL Code Using ANTS Performance Profiler
In this LIDNUG webinar, Mitchel Sellers walks through performance tuning best practices, and investigates how developers can use ANTS Performance Profiler to explore their application code and the SQL queries and execution plans behind it.
2014-12-05
7,720 reads
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,250 reads
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,462 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,315 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,257 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
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers