StreamInsight: A new way to think about analyzing data
Last night’s Oregon SQL user
group meeting was very enlightening. Mark Simms form the SQLCAT team came
down from Redmond to talk...
Using SQL Server Integration Services and StreamInsight Together
The purpose of this paper is to provide guidance
for enriching data integration scenarios by integrating StreamInsight with SQL
Server Integration Services. Specifically, we looked at the technical challenges
and solutions for such integration, by using a case study based on a customer
scenarios in the telecommunications sector.
What Sarbanes-Oxley Won't Do
Today we have a reprint of an editorial from Dec 4, 2005 as Steve is on vacation.
MDX Performance - burdens of IIF
I used to think naively that IIF is an innocent little function that can only do good and help me...
Working with SQL Server Profiler Trace Files
In a previous tip we looked at the steps to Create a Trace Template in Profiler. In this tip we will look at a few more tips such as creating a trace template from an existing trace file and saving a trace file to a SQL Server table.
Data Quality
Today we have an editorial reprinted from Dec 12, 2005 as Steve is on vacation. Steve talks about the hassles of poor data quality and why it can hurt a business.
Understanding Indexes
This article contains an introduction to SQL Server indexes and how they are used in your queries.
SQL Server: Natural Key Versus Surrogate Key
When designing a database to support applications you need to consider how you are going to handle primary keys. This article explores natural and surrogate keys, and discusses the pros and cons of each, allowing you to determine what makes the best sense in your environment when you are designing your databases.
Windows Instant File Initialization and SQL Server
One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right,...
A Variety of Interpretations
This week was T-SQL Tuesday week, the brainchild of Adam Machanic, and hosted by Pat Wright. The theme of Automation produced some very interesting posts. Some of them might inspire you to change the way you tackle the solutions for a variety of problems.
Blogs
I recommend Smart Brevity (book) for communications
By Brian Kelley
Following the advice in Smart Brevity improves communication.
SQL Server 2025 Developer Edition – One size fits all
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
Monday Monitor Tips: Learning While Using the Tool
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers