-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Confessions of a Microsoft Addict

Daniel Janik has been supporting SQL Server for 18 years as a DBA, developer, architect, and consultant. He spent six years at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has spoken at several SQL Saturday events across the US and Caribbean and regularly speaks at PASS local chapters.

Where to watch Ignite

In case you aren’t familiar with #MSIgnite, it’s a huge event where Microsoft debuts all the new shiny software that you’re going to want your hands on immediately and the conference is happening right now and goes until Friday.

You can watch and learn all about the exciting new things… Read more

0 comments, 183 reads

Posted in Confessions of a Microsoft Addict on 24 September 2018

Hello Denver! I’m speaking this weekend

For those of you in the Denver area, SQL Saturday is this weekend! I’m speaking and hope to see you there.

If you haven’t registered yet, no problem. The details are here:

http://www.sqlsaturday.com/774/eventhome.aspx

There’s a ton of great speakers and you don’t want to miss this one.

Read more

0 comments, 152 reads

Posted in Confessions of a Microsoft Addict on 11 September 2018

Are scalar functions really a bad thing?

I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog I’m going to explore if that’s the case. Let’s have a look.

It’s true that in many situations a scalar function is often a performance bottleneck; but, is there a… Read more

4 comments, 3,492 reads

Posted in Confessions of a Microsoft Addict on 10 September 2018

I’m speaking at SQL Saturday 749 : Baton Rouge

Hello Louisiana! It’s that time of year again. I’ll be speaking on Saturday August 11th in Baton Rouge with many other exciting speakers from around the country. My topic is a performance troubleshooting guide for DBAs; but, all are welcome to attend. This year is going to be amazing so… Read more

0 comments, 423 reads

Posted in Confessions of a Microsoft Addict on 27 July 2018

SQL Saturday Houston is this weekend

I’m speaking along with many other amazingly talented professionals, including Adam from Guy In A Cube. If you’re in the Houston, TX area be sure to head over to the SQL Saturday website to register. You can find more details here:  http://www.sqlsaturday.com/766/eventhome.aspx 

There are over 50 sessions across… Read more

0 comments, 253 reads

Posted in Confessions of a Microsoft Addict on 19 June 2018

Monday morning comic 2018-05-28

It always seems that when I give a talk on performance there are 100+ people packed in the room but when it comes to security there’s 10 to 15 people. No one likes patches, unless you’re talking about a puppy named patches or something that’s not related to updates; yet,… Read more

0 comments, 210 reads

Posted in Confessions of a Microsoft Addict on 28 May 2018

You know everything about GROUP BY. Do you?

SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in everything. I see a lot of people gravitate towards performance; but, that’s not the best place to focus. If you don’t know the fundamentals of the language then you will… Read more

1 comments, 5,431 reads

Posted in Confessions of a Microsoft Addict on 25 May 2018

Monday morning comic 2018-05-21

I decided to poke fun at ORM tools again this week. Hope you enjoy.

Read more

0 comments, 217 reads

Posted in Confessions of a Microsoft Addict on 21 May 2018

Back to basics: What is a HEAP table?

Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more than just a database; but, products that ingest data for analysis still need to get the data from a source, such as an OLTP SQL database.

So why are HEAP… Read more

2 comments, 3,738 reads

Posted in Confessions of a Microsoft Addict on 16 May 2018

I’m speaking: SQL Saturday Los Angeles 06-09-18

Hello California! I’m headed your way and will be speaking at SQL Saturday #773. The full schedule is live and there are a lot of great speakers to check out. If you’re in LA or the surrounding area on June 9th be sure to check it out. The event… Read more

0 comments, 198 reads

Posted in Confessions of a Microsoft Addict on 14 May 2018

Monday morning comic 2018-05-18

Here’s the first issue of a new Monday morning comic series. Hopefully some of you all get a giggle.

Read more

0 comments, 249 reads

Posted in Confessions of a Microsoft Addict on 14 May 2018

SQL Ops Studio extension development : Starting an adventure

I’ve been in technology a long, long time (more than 2 decades). Over the years, I learned Access which took me to Oracle and then translated nicely to SQL Server where I’ve spent the bulk of my time.

Along the way different projects had different requirements and challenges. To take… Read more

0 comments, 1,065 reads

Posted in Confessions of a Microsoft Addict on 26 April 2018

SQL Tuning: Finding statements for missing indexes

Missing indexes are an important part of the indexing strategy. I usually start with sys.dm_db_index_usage_stats to find both inefficient and unused indexes and then supplement with missing indexes.

The missing index DMVs are great but they’ve always been missing something.

What are they missing you ask? They currently tell… Read more

1 comments, 372 reads

Posted in Confessions of a Microsoft Addict on 20 April 2018

Query tuning: Apply yourself

It’s Friday and I’m ready for the weekend as I’m sure everyone else is. This weekend I’m looking forward to getting yard work done and browsing through the whoisactive SQL Ops Studio extension code.

I plan on writing a few posts on creating extensions; but, before we get to those… Read more

1 comments, 3,307 reads

Posted in Confessions of a Microsoft Addict on 6 April 2018

SSMS now has a vulnerability report

Security is an important and often overlooked function of technology. Don’t believe me? Go to a SQL conference and look how many people are listening to the perf tuning session vs the 3 people attending the security session.

Hopefully, this new feature will help those that are interested and those… Read more

0 comments, 334 reads

Posted in Confessions of a Microsoft Addict on 29 March 2018

The best overlooked addition to SQL 2016

Many of the widely advertised and talked about features of SQL Server or other software products focus exclusively on the hip new thing as opposed to quality of life. I’ve even recently heard people complain to Microsoft that they only focus on new features instead of making existing ones better. Read more

4 comments, 325 reads

Posted in Confessions of a Microsoft Addict on 7 March 2018

Classifying your data in Azure SQL DB for GDPR

Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio (SSMS); though, the management tasks available from SSMS for Azure SQL DB may not exist, such as: data classification.

You may have read my last post How to classify your… Read more

0 comments, 341 reads

Posted in Confessions of a Microsoft Addict on 6 March 2018

How to classify your data for GDPR

The right to be forgotten. It’s a concept that sounds great for people who are concerned about their personal information (PII) but it’s a complex issue for developers and data professionals.

GDPR is the European law that is intended to empower individuals with the ability to control the surface area… Read more

0 comments, 375 reads

Posted in Confessions of a Microsoft Addict on 5 March 2018

SQL Saturday Chicago: I’m speaking

If you’re in Chicago on March 17 and have some free time, why not check out all the cool kids?

You can check out the full event schedule here: http://www.sqlsaturday.com/719/Sessions/Schedule.aspx

There are a lot of great speakers and topics. Did I mention the Brent Ozar will be there? If that’s… Read more

0 comments, 226 reads

Posted in Confessions of a Microsoft Addict on 19 February 2018

STORPORT: Reading an ETL trace

One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it so much; but, I just do. When it comes to storage in Windows one of the best things you can do is capture an ETL trace for the STORPORT driver. Read more

0 comments, 1,791 reads

Posted in Confessions of a Microsoft Addict on 19 February 2018

Older posts