-->
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.

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, 165 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, 124 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, 4,977 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, 141 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,357 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, 136 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, 164 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, 839 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, 256 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,113 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, 222 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, 280 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, 222 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, 254 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, 184 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,582 reads

Posted in Confessions of a Microsoft Addict on 19 February 2018

PaaS and the ever changing role of the DBA

I’ve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list of DMVs and I’m a happy camper.

Perfmon is probably my best friend. It’s always there and happy to tell me the truth. It seldom falters and has helped me… Read more

0 comments, 1,481 reads

Posted in Confessions of a Microsoft Addict on 12 December 2017

How to be a successful innovator

Let’s say you have some obscure list of career goals for the year and one of those is to be a champion of innovation. I’m sure many of you reading this have probably run across goals like this before. I see a lot of people struggle with larger companies and… Read more

0 comments, 236 reads

Posted in Confessions of a Microsoft Addict on 9 November 2017

Always update your views

I last posted about changing a table without changing a view that represents the table and how this may affect the view.

In today’s quick post I’d like to show another issue brought about by not maintaining your views.

In case you missed the last post you can find it… Read more

1 comments, 288 reads

Posted in Confessions of a Microsoft Addict on 3 October 2017

Don’t forget to drop your views

I had a fairly puzzling issue today, which took a few minutes to figure out. Some time ago I created a “history” table. This was before temporal tables came out in SQL.

The history table and associated table were paired together so when a change is made to an account… Read more

4 comments, 2,688 reads

Posted in Confessions of a Microsoft Addict on 25 September 2017

Older posts