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

Latest Blog Posts

The Tabular Model Documenter is now a Power BI Template

A while back I created the Tabular Model Documenter Power BI model that can connect to your SSAS Tabular or Power BI model and display metadata about the model to help you see relationships, calculations, source queries, and more.  I had been meaning to turn it into a parameterized template… Read more

0 comments, 44 reads

Posted in Data Savvy on 19 September 2017

How to change Integration Services Catalog (SSISDB) database Master Key encryption password?

To change the Integration Services Catalog (SSISDB) database Master Key encryption password, run the following Transact-SQL statement:

USE [SSISDB];
GO

OPEN MASTER KEY DECRYPTION BY PASSWORD = N'[old_password]'; -- Password used when creating SSISDB
ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = N'[new_password]';
GO

In the above Transact-SQL fragment,… Read more

0 comments, 43 reads

Posted in Basit's SQL Server Tips on 19 September 2017

Join me at VS Live – Anaheim

We’re just a month away from Visual Studio Live in Anaheim where I’ll be speaking along with many others. Join me today, register with ANSPK14 and save $400. This gives you the 4-day, all access conference package for a reduced rate.

California coding, with experts in DevOps, Cloud Computing,… Read more

0 comments, 80 reads

Posted in The Voice of the DBA on 19 September 2017

Four PASS Questions–My Take #PASSElections

As part of the campaign material for this years election for Board of Directors; the candidates were asked to answer four questions. While I did put together a short two-minute video for PASS that will be published soon on the election site regarding these questions; I felt it prudent… Read more

0 comments, 31 reads

Posted in The SQL Professor on 19 September 2017

When Deadlocks Become Art

We’ve all had to solve deadlock issues. Identify the two conflicting pieces of code, work out an appropriate change to one of them to avoid the issue. Job done.

Occasionally you see a deadlock that has three nodes. Okay, a little bit more analysis and head scratching before the solution… Read more

0 comments, 29 reads

Posted in Matthew McGiffen DBA on 19 September 2017

Delete all the resources from a resource group using Windows PowerShell

Hello friends, Please find my new post at this link – https://social.technet.microsoft.com/wiki/contents/articles/40141.delete-all-the-resources-from-a-resource-group-using-windows-powershell.aspx Advertisements Tagged: Microsoft Azure, Powershell, resource group, Virtual Machine, Windows Powershell

Read more

0 comments, 48 reads

Posted in Kapil Blogs on 19 September 2017

SQL Server DB Migration – Cloning a database to another collation

Database migration is a vital task in any environment, complex or otherwise. Seamless migrations are the goal but the efforts required to ensure it are tremendous.

A global SQL Server Collation Sequence update is the answer to the puzzle, but it is a multi-step operation. The first step is to… Read more

0 comments, 40 reads

Posted in PowerSQL By Prashanth Jayaram on 19 September 2017

Azure, PowerShell, Databases and the PASS Summit

I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform conference in the world, PASS Summit 2017.

Now, I’m excited to say that I get to speak on three topics that are near and dear to my heart, Azure, PowerShell… Read more

1 comments, 94 reads

Posted in The Scary DBA on 19 September 2017

SQL Server Tracking Suspect Pages

Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table called suspect_pages? Well it does, but the question I want answering is what happens if the page within the suspect pages table is fixed? Does it automatically get removed/updated or… Read more

0 comments, 77 reads

Posted in All About SQL on 19 September 2017

Power BI Custom Visuals Class (Module 69 – Heatmap)

In this module you will learn how to use the Heatmap Custom Visual.  The Heatmap is useful for show data density on a map. It does this well because it aggregates data points and plots them to colors on a map.

Module 69 – Heatmap

Downloads

  • Power BI Custom Visual…

Read more

0 comments, 69 reads

Posted in Devin Knight on 19 September 2017

My Thoughts After Completing a Power BI Report Server POC

Last month I worked on a proof of concept testing Power BI Report Server for self-service BI. The client determined Power BI Report Server would work for them and considered the POC to be successful.

Here are the highlights and lessons learned during the project, in which we used the… Read more

1 comments, 120 reads

Posted in Data Savvy on 18 September 2017

Experimenting with VSCode instead of the ISE

I’ve been playing with PowerShell here and there, learning a few things. As I use the dbatools project, or

I saw a tweet from Rob Sewell on using VS Code for PoSh, which I’ve tried, but it felt cumbersome and hard. I didn’t spend much time on it before dropping… Read more

0 comments, 141 reads

Posted in The Voice of the DBA on 18 September 2017

Database Fundamentals #11: Why Learn T-SQL

If you’ve been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and a database with a table in it. You may have more if you’ve been practicing. Now would be the time to start adding data to the database, but first, I… Read more

0 comments, 113 reads

Posted in The Scary DBA on 18 September 2017

Uniquifier is a rather unique word isn’t it?

tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique.

Uniquifier is a rather funny name, and yet it’s very descriptive. If there is a key that must be made unique then SQL server will add a uniquifier to, well, make it unique.

Now, why… Read more

2 comments, 124 reads

Posted in SQLStudies on 18 September 2017

dataMinds Connect 2017 (win a ticket!)

Within two weeks the wait is over: the first edition of dataMinds Connect! For those of you wondering what I’m talking about, dataMinds Connect is the new name of the SQL Server Days (the biggest Microsoft Data Platform event in the Benelux). I’ve been a regular speaker at the… Read more

6 comments, 83 reads

Posted in Koen Verbeeck on 18 September 2017

SQL Server Schema Compare

A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition and I thought I would do a quick overview of it.

First thing, you can find the download from this link: https://www.visualstudio.com/downloads/  and once installed (making sure that you select… Read more

1 comments, 93 reads

Posted in All About SQL on 18 September 2017

Confidence Intervals for a proportion – using R

What is the difference between reading numbers as they are presented, and interpreting them in a mature, deeper way? One way perhaps to look at the latter is what statisticians call ‘confidence interval’.

Suppose I look at a sampling of 100 americans who are asked if they approve… Read more

0 comments, 89 reads

Posted in Mala's Data Blog on 18 September 2017

Monday Coffee: Should I learn powershell?

This month’s T-SQL Tuesday’s topic was set by Rob Sewell (b|t) and entitled Let’s all get PoSH

It had a massive response with loads of people writing about how they use powershell to automate tasks in their day to day work.

(Shameless self promotion – I… Read more

0 comments, 91 reads

Posted in The DBA Who Came In From The Cold on 18 September 2017

I want a new gadget with less features

Years ago I bought a Pebble smartwatch. I didn’t back the Kickstarter, but a few friends did and I liked the product. I wore mine for almost two years before it started to die. I can be rough on gadgets, so it’s possible I banged it and caused my own… Read more

3 comments, 256 reads

Posted in The Voice of the DBA on 15 September 2017

PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed

PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual SQL Servers – Right to Ludicrous Speed” has a few open slots for this Tuesday session. This topic is near and dear to my heart, and… Read more

0 comments, 117 reads

Posted in Technobabble by Klee from @kleegeek on 15 September 2017

Older posts