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

Archives: January 2015

SQL Saturday 360 in Israel

I had the pleasure to speak at SQL Saturday 360 in Israel. It was such a great event! We had two tracks, one for SQL Server and one for BI. There were more than 160 people who enjoyed free training, great food, networking and fun. There was even a beer… Read more

0 comments, 528 reads

Posted in Guy Glantser on 28 January 2015

New Power BI Preview and Pricing

Some exciting announcements were made today about the new Power BI cloud-based business analytics service.  Today Power BI is an add-on service for Office 365 that requires an enterprise-level license – about $50 per user per month.  Data transformation queries, data models and dashboard visualizations are all created using add-in…

Read more

1 comments, 525 reads

Posted in SQL Server BI Blog on 28 January 2015

Azure Enhancements – Time to take a look (and read the ebook.)


Recently I’ve become quite interested in the latest incarnation of Azure SQL Database.

For those that are unaware of some of the latest developments of this product, there was a new preview portal opened up towards the end of 2014.

This latest offering – know as version… Read more

1 comments, 6,405 reads

Posted in measure twice, cut once. on 27 January 2015

Excel BI Tip #18: Using CUBE Functions to Break Out of Pivot Tables

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

1 comments, 7,309 reads

Posted in DataOnWheels on 27 January 2015

DoD STIGs – Database Security Requirements Guide

Reading Time: 24 minutes

What are the Database SRG DoD Stigs?

The Database Security Requirements Guide, or SRG, is published as a tool to help you improve the security of your information systems.

They were originally intended for use with the Department of Defense Information Systems, but actually contain some… Read more

5 comments, 2,424 reads

Posted in WaterOx SQL on 27 January 2015

Friends Of Red Gate 2015

I’m excited that I’ve been asked to be back involved for another year in the Friends of Red Gate program. This program allows influential community members, community bloggers,  MVP’s and intuitive minds an inside track on helping with pre-existing and existing utilities that Red Gate has in their arsenal.

I… Read more

0 comments, 462 reads

Posted in The SQL Professor on 27 January 2015

Friends of Redgate 2015

Reading Time: 2 minutes

It’s official, I am in Friends Of Redgate for 2015!

Ok, the last few months have been an absolute whirlwind of activity for me. Back in October I was recognized by Microsoft by joining the ranks of the SQL MVPs out there, and now Redgate has… Read more

0 comments, 739 reads

Posted in WaterOx SQL on 27 January 2015

SQL #58–Where are my own templates in SQL Server Management Studio 2012

The secrete SQLFile.sql

We are all so used to clicking on the New Query icon (or the keyboard shortcut Ctrl+N). We know it will open a new query window in SSMS, an empty query window that is, but many of us never knew that something else was designed to happen… Read more

2 comments, 11,959 reads

Posted in Sherry Li's BI Corner on 27 January 2015

T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable

On Technet forum, Op was looking for a way to get table cardinality for all databases in an instance.  There are many ways to get the result. This post gives you an idea and SQL in which undocumented SP’s being called  “sp_MSforeachdb and sp_MSforeachtable”.

The above undocumented SP’s  iterate through… Read more

1 comments, 685 reads

Posted in PowerSQL By Prashanth Jayaram on 26 January 2015

Clustered Columnstore Indexes – part 47 (“Practical Monitoring with Extended Events”)

Continuation from the previous 46 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/

This post is a continuation from the the post 44, where I have listed different Extended Events.
In this post I will go into practical examples with detailed explanations on how to use those events.

Using ContosoRetailDW database as an… Read more

2 comments, 5,681 reads

Posted in Niko's blog on 26 January 2015

Downloading SQL Saturday data

I wanted to find out how many SQL Saturday’s I’d spoken at and how I ranked with others. I got a spreadsheet from Kendal Van Dyke at one point, but it was quickly out of date. However Kendal mentioned that there was an XML document on the site, and I… Read more

2 comments, 804 reads

Posted in The Voice of the DBA on 26 January 2015

An Overview on SQL Server Checkpoints

Commercial database systems like SQL server have many recovery mechanisms to restore data hardware or software failure. Checkpoints are part of such recovery mechanism.SQL Server Database Engine is programmed to perform changes or modifications to database pages in buffer cache (memory) first and after some processing the modification are written… Read more

1 comments, 9,860 reads

Posted in Basit's SQL Server Tips on 26 January 2015

My First Board Meeting

Parents, you know that feeling you get after you’ve brought home that brand new baby (or in my case, babies) where you suddenly say to yourself, “Oh damn. What have I done?” Yeah, that’s my feeling after my first board meeting. But let me give you a run-through of how… Read more

10 comments, 6,280 reads

Posted in The Scary DBA on 26 January 2015

Impact Player Series – Part 1

I wanted to start this series in regards to impact players that go above and beyond in the SQL Community. Coming from a sports background this resonates well with me and by the end of the year will have a 12 person roster.

I get asked a lot when I… Read more

0 comments, 448 reads

Posted in The SQL Professor on 26 January 2015

SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be fun (and good practice) to do them. Another major benefit is that it will force me to move out of my normal comfort zone. For… Read more

1 comments, 6,182 reads

Posted in SQLStudies on 26 January 2015

DBTA – 6 Reasons to Think About Upgrading to SQL Server 2014


If you’re an IT manager, the first thing I’d like to tell you is how invested Microsoft is in SQL Server. While earlier incarnations of executive leadership focused in other areas (anyone remember “Developers! Developers! Developers!”?), Microsoft’s new leadership is very bullish on SQL Server. And, why not? After… Read more

0 comments, 796 reads

Posted in Kevin E. Kline on 26 January 2015

SSRS Farm to Scale-Out Performance

SSRS Farm Overview

Building a SSRS farm will require Enterprise or Business Intelligence editions of SQL Server for versions 2012 and 2014.  SQL Server allows for the deployment of 2 or more servers running SQL Server Reporting Services to increase the performance of your reporting environment.

SSRS stores its data… Read more

1 comments, 1,086 reads

Posted in Business Intelligence and Enterprise Architecture on 26 January 2015

Availability Group Read-only Routing

This morning at a customer site I was researching an issue where Availability Group read-only routing was not working correctly. Quickly I was able to determine the issue was a misconfigured read-only routing URL list. In this blog post I’ll show you the requirements for read-only routing in Availability Groups,… Read more

1 comments, 2,658 reads

Posted in Anthony Nocentino's Blog on 25 January 2015

SQL Script to find the missing indexes

Performance tuning in SQL is important exercise and index creation is an important part of it. Below script will help in finding the missing indexes. Once you create these indexes, it will help in improving the Performance.

SELECT db_name(d.database_id) dbname

, object_name(d.object_id) tablename
, d.equality_columns
, d.inequality_columns
, d.included_columns
,'CREATE INDEX [missing_index_' +…

Read more

1 comments, 13,514 reads

Posted in Vivek's SQL Notes on 25 January 2015

Newer posts

Older posts