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
154 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,224 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,808 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
307 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
694 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
346 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
940 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
538 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,410 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
702 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...