Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

SQL Server Infernals – Circle 3: Shaky Typers

Choosing the right data type for your columns is first of all a design decision that has tremendous impact on the correctness of the database schema. It is not just about performance or space usage: the data type is the first constraint on your data and it decides what can… Read more

1 comments, 21 reads

Posted in SpaghettiDBA on 2 July 2015

Power BI Hands-On Workshop at PASS Global Summit

Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop. Bring your laptop and let’s build a real business intelligence (BI) solution using Power BI! In this deep-dive session, we build a complete solution.  You will need the Power BI Designer…

Read more

2 comments, 47 reads

Posted in SQL Server BI Blog on 2 July 2015

Database Drops in SQL 2012

In the previous article on this topic (which can be read here), I discussed the problem of having a database get dropped and the need to find out who dropped the database and when they dropped it.  In that article, I demonstrated how the information (at least some of it)… Read more

0 comments, 65 reads

Posted in SQL RNNR on 1 July 2015

Microsoft SQL Server MVP

Today I received an email notifying me that I have been awarded the Microsoft “MVP” award for my second year. An excerpt from Microsoft’s website states

“The Microsoft Most Valuable Professional (MVP) Award is our way of saying thank you to exceptional, independent community leaders who share their passion, technical… Read more

0 comments, 53 reads

Posted in Tim Radney - Database Professional on 1 July 2015

How to Grant limited permissions to create views in another schema?

How to Grant limited permissions to create views in another schema?

In SQL Server 2005 and 2008R2 you can grant permissions at the schema level and, in fact, this is what you’ll need to do to give them the ability to create the views. 


This script below creates an example… Read more

0 comments, 48 reads

Posted in SQLSERVERS’dba on 1 July 2015

What is Polyglot Persistence?

Polyglot Persistence is a fancy term to mean that when storing data, it us best to use multiple data storage technologies, chosen based upon the way data is being used by individual applications or components of a single application.  Different kinds of data are best dealt with different data stores.… Read more

0 comments, 56 reads

Posted in James Serra's Blog on 1 July 2015

Speaking at PASS Summit 2015 & SQL Live360! - WaterOx Consulting

Reading Time: 2 minutes

Seattle, here we come! I am excited, and honored that it is...

The post Speaking at PASS Summit 2015 & SQL Live360! appeared first on WaterOx Consulting.

Read more

0 comments, 58 reads

Posted in WaterOx SQL on 1 July 2015

Updating Extended Properties on a Table

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post.

I wrote recently about adding an extended property to a table. As part of what I was testing, I also needed to update properties,… Read more

0 comments, 85 reads

Posted in The Voice of the DBA on 1 July 2015

DBTA – Russian Hackers Steal 1.2b Internet Credentials: Or, Why the Heck Does this Keep Happening?!

I’m decidedly old-school in a few of my habits. My morning routine, barring anything out of the ordinary, is one such example. Typically, I’ll get up between 6:30 to 7:00 am, grab my first cup of coffee, and then chat with my daughters for a few minutes before seeing them… Read more

0 comments, 44 reads

Posted in Kevin E. Kline on 1 July 2015

SQL Saturday Field Notes

As you walk toward the entrance the door opens and there stands a volunteer smiling welcoming you in. You make your way into the building where you are ushered toward the sign in table; there is where you are greeted by more volunteers who help you get checked in and… Read more

0 comments, 49 reads

Posted in The SQL Professor on 1 July 2015

Blocking and deadlocking on purpose

Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling or prove a point and then you need to do the unusual.

Blocking and Deadlocking are based on lock requests and locking is handled differently depending on the TRANSACTION ISOLATION… Read more

0 comments, 45 reads

Posted in SQLStudies on 1 July 2015

Download SSMS, SSDT or SSDT-BI

It is a constant source of frustration for some people that it is hard to download SSDT or SSDT-BI or you download the wrong thing.

This is an example of some frustration: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c82354d0-2f88-4...

Anyway, this is now sorted as there is a single page to download SSMS or SSDT:

https://msdn.microsoft.com/en-us/library/mt238365.aspx?f=255&MSPPError=-...

Read more

0 comments, 145 reads

Posted in Ed Elliott's Sql Developer Blog on 30 June 2015

Leadership Training Possibility

I know a few people in the SQL Server community who have been involved in Scouting. A couple of them have taken or helped lead Scoutings leadership training program known as Wood Badge. It’s an amazing program. I won’t even attempt to tell you what Wood Badge has done… Read more

32 comments, 88 reads

Posted in The Scary DBA on 30 June 2015

Integrating Other Data Mining Tools with SQL Server, Part 2.1: The Minuscule Hassles of Minitab

By Steve Bolton

…………It may be called Minitab, but SQL Server users can derive maximum benefits from the Windows version of this professional data mining and statistics tool – provided that they use it for tasks that SQL Server doesn’t do natively. This was one the caveats I also… Read more

0 comments, 77 reads

Posted in Multidimensional Mayhem on 30 June 2015

Download SSMS 2015 as a standalone download.... finally!

I'm excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek

Two of the points made on the website look very promising:

New SSMS Installer - SSMS can now be installed with a light weight stand-alone web installer.

SSMS Updates -…

Read more

0 comments, 110 reads

Posted in SQL Barbarian on 30 June 2015

I’m Speaking at PASS Summit 2015

It’s this time of the year again, when PASS announces the speakers in the biggest SQL Server event in the world – PASS Summit. Like many others, I submitted my abstracts a few months ago and waited with anticipation for the results.

And I’m so proud and excited to say… Read more

0 comments, 110 reads

Posted in Guy Glantser on 29 June 2015

SQL Server Radio – Virtualization and Independent Consulting

I recently recorded a podcast with the SQL Server Radio group and discussed virtualization, high availability, and independent consulting topics. I had a lot of fun!

We talked about:

  • What’s important to know when virtualizing SQL Server
  • How to properly size your VM
  • What metrics to monitor when virtualizing
  • When…

Read more

0 comments, 126 reads

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

Sneak Preview – Podcast 010 - WaterOx Consulting

Reading Time: 1 minutes

Let’s Play A Game! So, just to tickle your fancy, here is...

The post Sneak Preview – Podcast 010 appeared first on WaterOx Consulting.

Read more

1 comments, 108 reads

Posted in WaterOx SQL on 29 June 2015

SQL Server 2016 CTP 2.1 has been released

Microsoft is all about rapid release cycles nowadays. We already experienced this with Power BI, where monthly new features and improvements have been added.
Now SQL Server appears to get the same treatment: SQL Server 2016 CTP 2.1 has just been released. There is nothing groundbreaking in this release… Read more

0 comments, 88 reads

Posted in Koen Verbeeck on 29 June 2015

I’m on WOxPod! Podcast

A few weeks ago, while at SQL Saturday Philadelphia, Chris Bell, SQL Server MVP and co-leader of PASS DC user group graciously sat me down and talked. We talked about me; who I’m, what I do, and what I like. You can listen to the podcast here.… Read more

0 comments, 68 reads

Posted in Sam Vanga on 29 June 2015

Older posts