SQLSaturday Speaking & Sharing
Recently, I caught a blog link on LinkedIn, of one SQL
Server professional talking about his experience speaking at a SQLSaturday,...
2014-11-24
877 reads
Blog Posts
TempDB Configuration Best Practices
1. Do not change collation of TempDB from the SQL Server instance collation. 2. Do not change the TempDB database owner from sa. 3. Do not drop the TempDB...
2014-11-24
14 reads
TempDB Configuration Best Practices
1. Do not change collation of TempDB from the SQL Server instance collation.
2. Do not change the TempDB database owner...
2014-11-24
5,474 reads
Using T-SQL to populate a Central Management Server
We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the...
2014-11-24 (first published: 2014-11-17)
6,996 reads
Clustered Columnstore Indexes – part 44 (“Monitoring with Extended Events”)
Continuation from the previous 43 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to the monitoring aspects of the Columnstore Indexes,...
2014-11-23
404 reads
Friday Followup For November 21, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-11-21
452 reads
Have We Devalued SQL Server Consulting?
Reading Time: 3 minutes
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training...
2014-11-21
337 reads
Have We Devalued SQL Server Consulting?
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training of SQL Server...
2014-11-21
624 reads
MDX #45–Find all the Calculated Sets and Their Calculation Scripts
Now we know how to find all the calculation scripts in a cube by querying the DMV $SYSTEM.MDSCHEMA_MEASURES.
MDX #43–Find a MDX...
2014-11-21 (first published: 2014-11-14)
5,726 reads
NJSSUG SSIS Performance Tuning
On November 18, 2014 I had presented to the New Jersey SQL Server User Group (NJSSUG) on SSIS Performance Tuning. ...
2014-11-21
409 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers