A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
2009-05-08
609 reads
Articles
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
2009-05-08
920 reads
Asymmetric Keys in SQL Server
I've been tech editing an encryption book for SQL Server. It's long overdue, and I think it will be a nice addition to any DBA's library. It also addresses a complicated subject that Books Online has inadequately covered. In fact, they've...
2009-05-08
2,065 reads
Attribute Discretization: Using the Automatic Method
Join BI Architect Bill Pearson as he continues his overview of Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.
2009-05-08
2,182 reads
SQL Server Optimization
This article describes different ways of improving the performance of SQL Server queries, with a focus on index optimization.
2009-05-08
5,250 reads
Enhancing the readability of your code: Table aliasing in sql
When writing SQL, picking good tables aliases can greatly enhance the readability of your code
2009-05-07
7,977 reads
Mastering SQL Server Profiler - Part 2: Profiler Architecture
This module, part 2 of the online training course "Becoming a Profiler Master", discusses the inner workings of Profiler.
2009-05-07
8,905 reads
Checking Up on Developers
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
2009-05-07
682 reads
Checking Up on Developers
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
2009-05-07
631 reads
Checking Up on Developers
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
2009-05-07
598 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers