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

Archives: June 2016

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


Der SQL Server 2016 ist da, und damit nun auch die „Version 2“ der In-Memory OLTP Engine, wenn man so will.

-           Was hinter der im SQL Server 2014 eingeführten In-Memory Engine von SQL Server steckt, habe ich auf diversen internationalen Konferenzen und in der IX bereits 2014 vorgestellt.…

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

2 comments, 848 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

5 comments, 947 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

10 comments, 3,041 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, 1,056 reads

Posted in The Voice of the DBA on 30 June 2016

Single package deployment does not replace package deployment

In my article, Single package deployment in SQL Server Integration Services 2016, I covered the exciting single package deployment feature available in SQL Server 2016 via SQL Server Data Tools (SSDT) 2015. I think in the midst of the excitement, some people started confusing this new feature with package… Read more

0 comments, 445 reads

Posted in Select SIFISO Blogs on 30 June 2016

Webinar on 25 New PowerShell cmdlets for SQL Server and more!

Next week Chrissy LeMaire ( b | t ), Laerte Junior ( b | t ), Rob Sewell ( b | t ) and I will be hosting a webinar covering the new PowerShell cmdlets that have just arrived in the end-of-June update of SSMS 2016.

You can register… Read more

3 comments, 527 reads

Posted in SQLvariant 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

1 comments, 2,311 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

2 comments, 2,517 reads

Posted in Alessandro Alpi on 30 June 2016

BimlScript – Get to Know Your Code Nuggets

In BimlScript, we embed nuggets of C# or VB code into our Biml (XML) in order to replace variables and automate the creation of our BI artifacts (databases, tables, SSIS packages, SSAS cubes, etc.). Code nuggets are a major ingredient in the magic sauce that is meta-data driven SSIS development… Read more

2 comments, 894 reads

Posted in Data Savvy 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

2 comments, 7,059 reads

Posted in SQLSailor.com 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

10 comments, 3,443 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, 906 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

10 comments, 3,284 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, 849 reads

Posted in The Voice of the DBA on 29 June 2016

Hearing Responsibility

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, 664 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

3 comments, 1,910 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

1 comments, 25,703 reads

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

If You Need to Think, You’re Doing It Wrong

A month ago, my wife and I were in Barcelona for a short vacation.

In one of the days, we entered a small place called Wok to Walk for dinner. The concept is simple: You build your dish by choosing your base (the type of noodles or rice), then your… Read more

1 comments, 619 reads

Posted in Matan Yungman 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, 3,107 reads

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

Older posts