Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
This white paper introduces Microsoft SQL Server developers to the international features of Microsoft SQL Server 2005. Topics covered include an explanation of Unicode, added support for supplementary characters in SQL Server 2005, the changes in collation in different versions of SQL Server, changes in data types, performance, updates on data providers, and new international support features in SQL Server 2005 Analysis Services and Integration Services.
In which Phil takes a break from a tedious bit of routine coding to build a Spam Filter in SQL.
Use XQuery scripting language to retrieve specific XML data type values in SQL Server. Learn to script and use Value() and Query() to retrieve single and multiple XML values.
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
Comments posted to this topic are about the item Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers