Why I Love SQLBits
Last week I attended SQLBits 2016 in Liverpool. I had such a great time, and I would like to share...
2016-05-08
167 reads
Guy Glantser
Why I Love SQLBits
Last week I attended SQLBits 2016 in Liverpool. I had such a great time, and I would like to share...
2016-05-08
1,236 reads
Partition to Filegroup Mapping in SQL Server
Suppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition...
2016-05-05 (first published: 2016-04-25)
2,847 reads
How to Use Parameters Like a Pro and Boost Performance
Yesterday I presented my favorite session “How to Use Parameters Like a Pro and Boost Performance” in the DBA Fundamentals...
2016-03-01
326 reads
From XML to JSON – script
Last Thursday I presented my session “From XML to JSON” in the Application Development PASS Virtual Chapter. The session is...
2016-02-28
707 reads
Introduction to Big Data
So you’ve been working as a DBA or a BI developer for several years now. You know your stuff very...
2016-02-21
368 reads
Hadoop Fundamentals – The Presentation
Few days ago (28/12) I delivered a full-day seminar about Hadoop Fundamentals. It was part of the Expert Days 2015...
2015-12-30
953 reads
How to Compare Tables in SQL Server
One of our customers has recently asked me the following question (I changed just the business case):
The Problem
“I have a...
2015-12-22
554 reads
Hadoop Fundamentals
Have you heard about Hadoop, but never really understood what it’s all about?
Do you need to learn about Hadoop, either...
2015-12-14 (first published: 2015-12-10)
3,424 reads
The Power of Data in the Cloud
Today we had a full-day event in Microsoft about the data offerings and possibilities in the Microsoft cloud platform – Azure....
2015-11-19
716 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers