Setting Expectations–T-SQL Testing
I don’t know who started this pattern, as I’ve seen it in a few places. It could have been Sebastian...
2014-11-03
882 reads
Blog Posts
SQL Server Database Mirroring Monitoring
SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of...
2014-11-03
6,416 reads
SQL Server Database Mirroring Monitoring
SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of Database Mirroring to ensure that everything is working...
2014-11-03
13 reads
SQL Server Table Partition Example
Why Use a SQL Server Table Partition
Data warehouses and data repositories often have tables that store millions of records and...
2014-11-03
5,171 reads
SQLPASS Summit 2014 is here, The largest SQLServer Conference !
November is not the right time to visit Seattle (Blame the rain!), but I kinda like November because that’s when...
2014-11-03
539 reads
What is a data warehouse and why do I need one?
While the data warehouse isn’t a new concept, many are left wondering – what is a data warehouse? And why do I need one? I’m sad to tell you...
2014-11-03
12 reads
Bon Voyage fellow PASS Summit 2014 Attendees!
For the first time ever, I will be a PASS Summit Attendee! I’m very excited about going and I’ll be...
2014-11-02
472 reads
How I Got Here: 5 Years At Pragmatic Works
I recently celebrated my 5 year anniversary at Pragmatic Works. Boy, how time flies by. It feels like just the...
2014-11-02
1,655 reads
Non use of persisted data – Part Three
A long time ago I looked at some reasons as to why persisted computed columns ( and therefore indexes on those...
2014-11-02
367 reads
PASS Summit 2014 Diary – Day 0
This week, I’m attending two different summit events in the Seattle area. On Sunday through Tuesday, I’ll be participating in...
2014-11-02
759 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