Raw Materials - Order! Order!
Leibniz breaks out of a buyer's dilemma that might defeat a subtler mind.
2012-01-10 (first published: 2010-06-30)
9,241 reads
Articles
SQL Test: Seeing Red Change to Green
Rob Sullivan is one of the users who are helping shape the way that SQL Test develops, and here he explains what is going on, and why.
2012-01-10
1,883 reads
SSMS Shared SQL Templates
This article describes how to use the built in repository for SQL Server Management Studio Templates and how to customize and share a common repository with your team.
2012-01-09
8,972 reads
Constraints and the Test-Driven Database
Bad data always seems to appear when, and where, one least expects it. Sam explains the great value of a defensive approach based on constraints to any team that is developing an application in which the data has to be exactly right, and where bad data could cause consequential severe financial damage. It is perhaps better seen as creating a test-driven database.
2012-01-09
2,574 reads
TSQL Challenge 73 - Implement Word Wrapping in TSQL
The challenge is to wrap the text by specified position.
2012-01-09
2,883 reads
Understanding and Using APPLY (Part 1)
The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.
2012-01-06 (first published: 2010-04-12)
52,000 reads
T-SQL Development, or: How I Learned to Stop Worrying and Love Word
Microsoft Office Word is useful. There, I have confessed it, it's useful to me while I am working with TSQL. It's possibly only the search and replace function that I like but it's wrapped in Word so I have to take it like that. I use it a lot to help me capture the results of a stored procedure.
2012-01-06
4,436 reads
ETL Magic with SSIS – Part I
The first part of two parts of a paper discussion the implementation of a "real-world" ETL example using SSIS.
2012-01-05
15,733 reads
Raw Materials - Decisions, Decisions
Centuries ago, the philosopher Leibniz had a dream that all decisions could be made by machine. Today, his vision comes to life, more or less.
2012-01-05 (first published: 2010-06-23)
9,075 reads
Using bit columns with NULLs when three options exist in SQL Server
Frequently surveys ask yes/no questions and use a bit datatype. What are the effects of allowing this column to be NULL in a SQL Server table? Check out this tip to learn more.
2012-01-05
4,275 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers