Farewell Brook Ranne
For members of the SQL community in Orlando and Chicago you’ve probably heard that Brook Ranne died on March 29,...
2014-04-15
688 reads
Blog Posts
MDX # 40 – CROSS JOIN does not return Cartesian product of two hierarchies from the same dimension
Correction
4/25/2014
Thanks to Chris Webb’s comment (see the comment section). I am making a correction on this blog.
The title of this...
2014-04-15
1,919 reads
Optional Parameters Causing Index Scans
Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even...
2014-04-15
729 reads
Overview of Published Articles – 2014Q1
Since I write at different places – this blog, Intense School and MSSQLTips.com - someone recently asked me if I could provide an...
2014-04-15
493 reads
Parallel Data Warehouse (PDW) AU1 released
Microsoft’s PDW has seen a big boost in visibility and sales over the past year, and part of the reason...
2014-04-15
1,376 reads
PASS SQLSaturday Events: May 2014
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2014-04-15
492 reads
Rounding versus truncating
Be careful when implicitly converting data types in T-SQL. Directly assigning 1.5 (either as a FLOAT or a NUMERIC) to...
2014-04-15
1,045 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-15 (first published: 2014-04-07)
3,306 reads
SQL Server 2000 || Disable sa login
Question : How to disable sa user in SQL Server 2000?
Reason : Due to Security requirement of audit, We have to disable...
2014-04-15
1,986 reads
SQL Server First Aid
If you take basic first aid, say a CPR course, you’ll learn a handy mnemonic for the primary assessment you...
2014-04-15
1,116 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers