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

Archives: February 2015

Clustered Columnstore Indexes – part 49 (“Data Types & Predicate Pushdown”)

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

Note: Updated on 05th of March 2015 with information on SQL Server 2012.

Having blogged a couple of times on the matters of Segment Elimination (“Data Loading for Better Segment Elimination”, “Deleted Segments Elimination” ), I decided… Read more

13 comments, 1,030 reads

Posted in Niko's blog on 28 February 2015

Secure your password with HashBytes TIP #89

Dear Friends,

In my last article (TIP 87) I wrote about PWDENCRYPT.  I forgot to write few details but thanks to all my talented friends & blog readers who guided me by providing there feedback on post.

I respect their inputs and always interested to get more inputs. Thanks… Read more

0 comments, 836 reads

Posted in Rajat Jaiswal-337252 on 28 February 2015

Outlier Detection with SQL Server, part 3.6: Chauvenet’s Criterion

By Steve Bolton

…………This is the last of six articles I’ve segregated in this middle of my mistutorial series on identifying outlying values with SQL Server, because they turned out to be difficult to apply to the typical use cases DBAs encounter. After this detour we’ll get back on… Read more

0 comments, 1,387 reads

Posted in Multidimensional Mayhem on 28 February 2015

Impact Series – Part 2

It’s that time again to add another impact player to the roster; this time for the month of February.

This month the nod goes to none other than Jason Strate (Blog|Twitter). A few years back I sat in on one of Jason’s sessions at PASS Summit.… Read more

0 comments, 655 reads

Posted in The SQL Professor on 27 February 2015

Impact Series – Part 2

It’s that time again to add another impact player to the roster; this time for the month of February.

This month the nod goes to none other than Jason Strate (Blog|Twitter). A few years back I sat in on one of Jason’s sessions at PASS Summit.… Read more

0 comments, 416 reads

Posted in The SQL Professor on 27 February 2015

SQLSaturday Phoenix

This weekend, I’m flying to Phoenix to be a part of SQLSaturday there. I will present two new sessions on Saturday:

Extending Your Availability Group for Disaster Recovery

Did you know that SQL Server Availability Groups can be a great solution for disaster recovery?  Availability groups have become well known… Read more

0 comments, 667 reads

Posted in The Data Files on 27 February 2015

Friday Followup For February 27, 2015

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Building (for FREE) a Virtual Server for SQL Demos
  • Cheating DBCC To Fix Index Corruption
  • Do You Need…

Read more

0 comments, 644 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 27 February 2015

Gimme A Break! Taking Mental Health Days - WaterOx Consulting

Reading Time: 3 minutes

  Burnout! You have been stressing over the big project you have...

The post Gimme A Break! Taking Mental Health Days appeared first on WaterOx Consulting.

Read more

1 comments, 1,436 reads

Posted in WaterOx SQL on 26 February 2015

My Upcoming Speaking Engagements

March 4 – Charleston PASS, Charleston, SC

What Admins Absolutely Must Know About SQL Server Security

There are so many security tips out there for SQL Server. Almost all of them are rated as a best practice. What do you listen to? What do you focus on? In this… Read more

0 comments, 661 reads

Posted in Databases – Infrastructure – Security on 26 February 2015

My Upcoming Speaking Engagements

March 4 – Charleston PASS, Charleston, SC

What Admins Absolutely Must Know About SQL Server Security

There are so many security tips out there for SQL Server. Almost all of them are rated as a best practice. What do you listen to? What do you focus on? In this… Read more

0 comments, 378 reads

Posted in Databases – Infrastructure – Security on 26 February 2015

Operational Data Store (ODS) Defined

I see a lot of confusion on what exactly is an Operational Data Store (ODS).  While it can mean different things to different people, I’ll explain what I see as the most common definition.  First let me mention that an ODS is not a data warehouse or data mart.  A… Read more

7 comments, 7,402 reads

Posted in James Serra's Blog on 26 February 2015

ICYMI: Ten Query Techniques Every SQL Programmer Should Know (Video)

Update 09-Mar-2015: The original PASS links I provided were behind a firewall. Thanks reader MMcDonald, we have a working link on YouTube.

One of the benefits of joining PASS is that you get access to their expansive library of conference videos. (Membership is free. So join now. What’dya want, a… Read more

6 comments, 8,392 reads

Posted in Kevin E. Kline on 26 February 2015

Monitor Query Statistics

One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task. Monitoring is a strategy, and a good DBA should have a well-defined plan for carrying out this strategy. But I’m not here to talk about monitoring as a whole. I… Read more

2 comments, 7,868 reads

Posted in Guy Glantser on 26 February 2015

Exam Prep 70-463: SSIS Expressions

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

3 comments, 8,219 reads

Posted in Cleveland DBA on 26 February 2015

How to do DevOps as a SQL Server DBA

You recognize that you need to provide a pipeline for database deployments, that you need to automate as much support for your development teams as you possibly can, that you have to have testing in place to ensure protection of the production environment, that you need to speed your processes.… Read more

2 comments, 1,090 reads

Posted in The Scary DBA on 26 February 2015

Dynamic Data Masking

Dynamic Data Masking
FEBRUARY 26, 2015

Have you ever wanted to only show parts of a field to certain sets of users such as credit card numbers, telephone numbers or last names? This functionality is now possible in Azure SQL Database with Dynamic Data Masking. This month, Microsoft has continued…

Read more

0 comments, 8,095 reads

Posted in Pie in the Sky on 26 February 2015

Parsing SQL Saturday Data – Getting Titles from the XML document

I’m continuing on with my project to grab SQL Saturday data and automatically insert it into a SQL Server database. In this piece, I’m picking up from the last one where I had a loop to load all XML documents in a folder based on a pattern.

This time I… Read more

0 comments, 1,045 reads

Posted in The Voice of the DBA on 25 February 2015

The SQL Sentry forum for SQL Statement Tuning

The SQL Sentry forum for SQL Statement Tuning

Have you ever looked at our community site specifically dedicated to helping users tune their SQL queries, http://answers.SQLPerformance.com?

You can easily upload an execution plan directly from our free Plan Explorer tool or from good ol’ SQL Server Management Studio to… Read more

1 comments, 938 reads

Posted in Kevin E. Kline on 25 February 2015

Using sp_DBPermissions and sp_SrvPermissions v6.0

It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting.

Changes

sp_SrvPermissions
— V5.5
— 7/22/2014 – Changed strings to unicode
— V6.0
— 10/19/2014 – Add @UserLikeSearch and @IncludeMSShipped parameters.

sp_DBPermissions
— V5.5
— 7/15/2014 – Bunch of changes… Read more

1 comments, 847 reads

Posted in SQLStudies on 25 February 2015

Older posts