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

Latest Blog Posts

Test Database Compatability with dbatools

I really like the dbatools project. This is a set of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these items.

One of the items that few DBAs think… Read more

0 comments, 103 reads

Posted in The Voice of the DBA on 20 September 2017

Does rebuilding my clustered index also rebuild my non-clustered indexes?

I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered index would cause non-clustered indexes to be rebuilt as well, because the non-clustered index includes the clustered index in it. This assumption is wrong. On SQL Server 2000, this only… Read more

0 comments, 52 reads

Posted in Born SQL with Randolph West on 20 September 2017

An open letter to the PASS community (2017)

PASS is our community.

It may sound a little cliche, especially with the current political climate in the US and other nations, but it’s absolutely true. PASS is our community. It’s made up of data professionals from around the globe. All of us are volunteers, from the attendees to the… Read more

0 comments, 73 reads

Posted in The Data Files on 20 September 2017

Hmmm… What’s This?

OK So, I am doing some digging and peaking around again in SQL Server and came across a database option called Date Correlation Optimization Enabled = False. Honestly, I had no clue what it did, so I took it as a learning opportunity to look into it and do… Read more

0 comments, 60 reads

Posted in SQLEspresso on 20 September 2017

TSQL2sDay – Get-PostRoundup

First an apology, this round up is late!

The reason for that is an error in the PowerShell testing module Pester (That’s not completely true as you shall see!!)

I spoke in Stuttgart at the PowerShell Saturday last weekend and had intended to write this blog post whilst travelling, unfortunately… Read more

0 comments, 69 reads

Posted in SQL DBA With A Beard on 20 September 2017

Dieser Blog ist umgezogen // This Blog has moved: http://andreas-wolter.com/blog/

Liebe Leser
dieser Blog ist hiermit nur noch „Archiv“ und wird nicht mehr weiter gepflegt.
Seit August 2017 finden sich neue Artikel ausschließlich unter der neuen URL:
http://andreas-wolter.com/blog/

Dear Readers
this blog is now merely an „archive“ and no longer being updated.
Since August 2017 new articles are exclusively available…

Read more

0 comments, 64 reads

Posted in Andreas Wolter SQL Server & BI blog (English / German) on 20 September 2017

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

6 comments, 100 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, 110 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, 142 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, 69 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, 74 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, 93 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, 77 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, 121 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, 107 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, 129 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

4 comments, 145 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, 157 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, 132 reads

Posted in The Scary DBA on 18 September 2017

Older posts