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,799 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
939 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
536 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,409 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
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers