The “Perfectly Optimized” Page – #infographics
The “Perfectly Optimized” Page infographic states that there is no such thing as a “Perfect Page”. But don’t be discouraged!...
2014-02-24
917 reads
Blog Posts
What’s the difference between a temp table and a table variable?
I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the...
2014-02-24
1,104 reads
Why I Developed SQL Code Guard: A Fairy Tale from a DBA
A long time ago, in a galaxy far, far away….
About ten years ago, I realized I was spending more than...
2014-02-24
827 reads
@RedHat and @Hortonworks fuse Hadoop and cloud in new partnership
A Strategic alliance between the biggest Linux vendor and the leader in fully opensource hadoop is a killer combo. Read...
2014-02-23
440 reads
AzureCAT Chalk Talks at Strata 2014 #azure #Azurecat #strata
This week the AzureCAT team is excited to make our first team appearance at the Strata conference. For those of you...
2014-02-23
451 reads
Deep learning might make your Netflix recommendations a lot better
Streaming video giant Netflix is experimenting with the advanced artificial intelligence method commonly known as deep learning, it explained on...
2014-02-23
877 reads
February '14 Acadiana SQL Server User Group
I am honored to be the very first presenter of the new PASS chapter in Lafayette, Louisiana this Tuesday, presenting...
2014-02-23
612 reads
February '14 Data Architecture Virtual Chapter Meeting
I will be speaking and whiteboarding for Data Architecture Virtual Chapter meeting on February 27, 2014 on the fitting topic...
2014-02-23
469 reads
Rebuild all indexes on all tables in the SQL Server database
One of the key tasks of a DBA is to maintain the database indexes and make sure they are not...
2014-02-23
2,996 reads
Removing part of string before and after specific character using Transact-SQL string functions
Problem
Today, one of the developers come to me and asked me the question that is there any T-SQL function that...
2014-02-23
47,456 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