Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Python Distributions

Python Distributions Python is free and open source software.  A programmer could download the executables for Python directly from the official site or even download the sourcecode and compile it themselves.  But for someone wanting to get straight to programming … Continue reading

Read more

0 comments, 61 reads

Posted in SQLWise on 1 July 2016

The SQL Server 2016 In-Memory Evolution – from row-store to columnstore to in-memory operational analytics




(Rohfassung vom 30.6., weitere Updates in den nächsten Tagen.)

Der SQL Server 2016 ist da, und damit nun auch die „Version 2“ der In-Memory OLTP Engine, wenn man so will.
In diesem Artikel möchte ich die Neuerungen und Verbesserungen beleuchten, an denen Microsoft die letzten 2 Jahre…

Read more

My Feedback on my PASS Abstracts Feedback

Brent Ozar recently published the feedback he got on his abstract submissions for PASS Summit 2016 and, as he often does, started a trend which some others followed. I think the feedback is interesting and useful for speakers that plan to improve their own submissions for the years to come,… Read more

1 comments, 59 reads

Posted in SpaghettiDBA on 30 June 2016

PowerShell CMDLets added for SQL2016 Always Encrypted

The post on the SQLServer blog at TechNet by the SQL Server Tools Team today made me jump out of my seat.

The July update for SSMS includes the first substantial improvement in SQL PowerShell in many years. We owe a lot of thanks for this effort to the great…

Read more

0 comments, 63 reads

Posted in SQL DBA With A Beard on 30 June 2016

SQL Server 2016, Database Mail and .Net 3.5 Framework

There were so many cheers when Microsoft announced that the .Net 3.5 Framework was no longer a pre-requisite for installing SQL Server starting with SQL Server 2016.  Folks were so excited, until they started testing certain pieces of the product, specifically Database Mail.  That’s right, if you want to use… Read more

0 comments, 82 reads

Posted in SQL Swimmer on 30 June 2016

Basic XML Node Query–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I saw a question recently about querying an XML document. Certainly avoid this in the database if you can, but there are times you need to.… Read more

0 comments, 84 reads

Posted in The Voice of the DBA on 30 June 2016

Power BI Pulse Chart vs. Dancing bars in Excel

[2016-Jun-30] Recently Microsoft Power BI has been enhanced with a new Pulse Chart custom visualization (Visual Awesomeness Unlocked: Pulse Chart) which is extremely good and useful for a visual data story telling. I believe that the less we have people explaining their data visualization and more we let…

Read more

0 comments, 46 reads

Posted in Data Adventures on 30 June 2016

Managing migrations with RedGate SQL Source Control 5

This is a good day for me. I’ve finally tried the improved migrations feature in the latest version of RedGate SQL Source Control  and I’ve tested the feature against all my typical cases so that I can share my findings with you.

What is the migrations feature?

When a change… Read more

0 comments, 68 reads

Posted in Alessandro Alpi on 30 June 2016

AlwaysOn Availability Group Database Level Health Detection – SQL Server 2016

SQL Server 2016 AlwaysOn AG got many improvements, and I’m pretty impressed with the log throughput improvements and redo improvements based on some of my test cases(A detailed blog post on that will follow soon). In this blog post we will look at another key improvement, ie Database Level Health… Read more

0 comments, 73 reads

Posted in on 30 June 2016

5 More Power BI Tips

I’ve had this blog post in my mind to write for the past month or so and I’m finally just getting around to it while I’m waiting to board my flight back home.

Check out my first 5 Power BI Tips here

These are just five more Power BI tips… Read more

1 comments, 100 reads

Posted in SQL with Dustin Ryan on 29 June 2016

The Desktop Rebuild–Part 3

This is the last part of this series, at least for now. If you haven’t seen Part 1 and Part 2, feel free to check them out.

After I got through Part 2, I was working again. In fact, I continued to chocotaley install a few things, but for… Read more

2 comments, 155 reads

Posted in The Voice of the DBA on 29 June 2016

Is Today Your Last Day Working With SQL?

Please entertain this thought for a moment – If today was your last day working with SQL how would you spend it?

Now, this post is assuming you, as the reader, are working with SQL in some form or fashion; however take the question and apply it to some other… Read more

7 comments, 75 reads

Posted in The SQL Professor on 29 June 2016

Better Explorer on High dpi Displays

I’ve got a high dpi display on my laptop. The recommended resolution is 2560×1704. That’s small. I have had all kinds of issues with SSMS, VS, and various other applications, including a few from Redgate.

The other day I was looking at the Explorer window from about 2 feet away… Read more

4 comments, 113 reads

Posted in The Voice of the DBA on 29 June 2016

Hearing Responsibility - Syndication – WaterOx Consulting

A while ago I was watching Shark Tank on TV and at one point Robert Herjavich (T|B) made the great quote above. When I heard that statement I stopped the show immediately. I went back (Thank you whoever made rewindable TV possible!) and listened to it again to make sure…

Read more

0 comments, 97 reads

Posted in WaterOx SQL on 29 June 2016

Finding, disabling and enabling foreign keys

Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if you have to reload data in a table. Lets say developers would like you to overwrite the data from several tables in the test environment with data from the… Read more

0 comments, 88 reads

Posted in SQLStudies on 29 June 2016

Uninstalling SQL Server from the Command Line to Remove Unwanted Background Instances

I had a note (or ‘action item’) to make sure that people were informed regarding the ‘uninstall’ of SQL Server, since non-DBA server administrators would like to know more detail on this.  The process is not obvious from Control Panels’ Programs and Features (long list of components), so…

Read more

0 comments, 82 reads

Posted in The Database Hive for SQL Server DBAs on 29 June 2016

Introducing SQL Server Reporting Services

In an earlier post I introduced the SQL Server umbrella and briefly discussed a number of products that make up the SQL Server stack. One of those products and a key element of the SQL Server family is SQL Server Reporting Services (SSRS). SQL Server Reporting Services is Microsoft’s enterprise…

Read more

0 comments, 106 reads

Posted in The SQL DBA in the UK on 29 June 2016

Automatic Seeding Very Large Databases in SQL Server 2016

There are a lot of new features in SQL Server 2016. Availability Groups by itself got a lot of new features.  Being that I am the founder of the High Availability and Disaster Recovery Virtual Chapter, I plan on blogging about the new availability group features.

Today, I wanted… Read more

1 comments, 107 reads

Posted in John Sterrett on 29 June 2016

Speaking at PASS Summit 2016

I’m very honored to be speaking at the PASS Global Summit again this year in Seattle during the week of October 24th. I cannot convey just how much this means to me, as speaking at any event is a gift and a thrill, especially a conference like the PASS… Read more

0 comments, 96 reads

Posted in Technobabble by Klee from @kleegeek on 29 June 2016

Does my database have data type drift?

Over the years I have come to see that every database has what I call data type drift. Simply put, data type drift is when you have columns with the same name but different data types or length. I’d say about 97% of databases I’ve reviewed have some form of… Read more

2 comments, 136 reads

Posted in Confessions of a Microsoft Addict on 28 June 2016

Older posts