-->
Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: October 2015

PASS 2015 Session Report – Azure SQL DW Integration with the Azure Ecosystem & End of PASS 2015

PASS 2015 continues (and finishes up today!) in Seattle.

Its been an amazing conference this year with a few things really hitting home;

  • Amazing technology announcements around SQL 2016 CTP3
  • Incredible advances in almost every component in Azure Data Services
  • Full and seamless SQL/Azure ecosystem integration – and…

Read more

0 comments, 506 reads

Posted in Mr. Fox SQL on 31 October 2015

Scripts and Slide Deck: The Data Loading Performance Presentation at PASS Summit

I have just finished delivering my session, The Data Loading Performance Presentation at PASS Summit 2015. It went very well, and I’d like to thanks anyone who attended.

Here’s a glimpse at the start of the session:

The scripts and slide deck can be downloaded from here.

Stay tuned… Read more

2 comments, 537 reads

Posted in Matan Yungman on 30 October 2015

Freaky statistics feature

SQL Server statistics can make things a bit freaky. You might have read one of my previous articles portraying a specific performance issue caused by stale statistics – No thrills about spills.

In this article I will talk a bit about the distribution steps in statistics and something that… Read more

0 comments, 897 reads

Posted in SQLYSE with Pankaj Manek on 30 October 2015

From PASS Summit to MVP Summit

This was a really great week!

So many sessions by great speakers, lots of community events, parties and fun. I met a lot of people, some are old friends and some are new friends that I hope to keep in touch with. I also learned a lot. My personal interest… Read more

0 comments, 502 reads

Posted in Guy Glantser on 30 October 2015

Catching specific statements using new MI008 "Statement used" rule

Imagine that you want (for some reason) prohibit usage of some statement (or statements), eg - CURSOR
How can you find if this statement is used in the script? To perform this task you should use newly added rule MI008 "Statement used"


First you must mark this rule as "Warning"…

Read more

1 comments, 1,280 reads

Posted in SQL Code Guard on 30 October 2015

the game

So things are messed up. Bad. I mean, you lost a $2.7 Billion Dollar Secret Blimp or your team accidentally sent your client $6 Billion Dollars bad. Messed up.

In business as in life we have challenges, problems, “opportunities” as we like to say. Things get complicated and life doesn’t… Read more

0 comments, 538 reads

Posted in @chuckboycejr on 30 October 2015

Tricks and Treats with XE

Halloween is a great time of year. It is unfortunate that it is just one day of the year. That said, I do like to think of the month of October as Halloween Month. I have several posts over the years that geek out over the cross-over between Halloween and… Read more

0 comments, 484 reads

Posted in SQL RNNR on 30 October 2015

How to find blocked processes

Blocked processes are often a big problem for DBAs, because they’re difficult to monitor. We receive desperate calls saying “Everything is slow!” but before we can do anything a second call arrives saying, “Don’t worry, everything’s OK again!”

Most of the time, this happens because a badly-behaved process blocks other… Read more

7 comments, 5,446 reads

Posted in SQLSERVERSdba on 30 October 2015

PASS 2015 Session Report – Understanding Real World Big Data Scenarios

PASS 2015 continues in Seattle, and today was my session at 1045am on Using Azure Machine Learning (ML) to Predict Seattle House Prices.  The background and info on my session is here http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=7794

Overall I was pretty happy with how it went - and I think everyone who attended…

Read more

1 comments, 467 reads

Posted in Mr. Fox SQL on 30 October 2015

Five simple backup and recovery plans for SQL database

Introduction

Creating a good backup and recovery plan for SQL database is a very important task of a database administrator. A Database administrator must have the knowledge about the troubles of SQL Server and also a quick strategy, which is suitable for the trouble. Many organizations hire accidental database administrators… Read more

1 comments, 3,393 reads

Posted in Zora's SQL Tips on 30 October 2015

PASS Summit Key Note Day 2 – Recap

As I sit here in an offshoot of the convention center, I started reflecting back to this morning’s keynote for various reasons. It got me thinking about 3 key words for myself when it comes to this conference:

  1. Impact
  2. SQL Family
  3. Dedication

How did I come to these three key… Read more

0 comments, 421 reads

Posted in The SQL Professor on 29 October 2015

Columnstore Indexes – part 71 (“Change Data Capture, Change Tracking & Temporal”)

Continuation from the previous 70 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

In the SQL Server world of data modification tracking, there are 2 very important features, which are called Change Data Capture (CDC) and Change Tracking (CT). Both of them allow you to understand the changes… Read more

0 comments, 416 reads

Posted in Niko's blog on 29 October 2015

PASS Summit Session Follow-up: The Plan Cache Whisperer

I’ve wrapped up my session at my first session at this year’s PASS Summit.  My session this Thursday was The Plan Cache Whisperer: Performance Tuning SQL Server [DBA-313].

The session appears to have gone really well and the content has been uploaded to the PASS Summit for download.… Read more

0 comments, 371 reads

Posted in StrateSQL on 29 October 2015

Columnstore Indexes – part 70 (“Filtered Indexes in Action”)

Continuation from the previous 69 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

This blog post is the continuation from the previous one, where I have described the Operational Analytics for Rowstore.
I have tried to create a filtered index, but the performance results that I was… Read more

0 comments, 355 reads

Posted in Niko's blog on 29 October 2015

PASS Summit 2015 Keynote – Day 2

Today is the second day of the SQL PASS Summit in Seattle, Washington. I’ll be live blogging today’s keynote address. This post will be updated throughout the keynote. Don’t forget you can watch the live stream on PASS TV. Adam Jorgensen, current EVP of finance (and future president) of PASS… Read more

1 comments, 491 reads

Posted in Tim Mitchell on 29 October 2015

PASS Summit 2015: So Far

It’s Kilt Day!

I want to give a quick assessment on how the Summit has been for me so far. Monday, as is true for the rest of the week, I served two masters. In the morning I went to the Redgate SQL in the City event. In the afternoon… Read more

1 comments, 370 reads

Posted in The Scary DBA on 29 October 2015

Default Sessions

So I have blasted through a lot of technical articles about Extended Events. There is a lot of groundwork that has been covered with layers of building blocks that have been stacked. Now it’s time to take a step back as I near the end of the original goal for… Read more

0 comments, 475 reads

Posted in SQL RNNR on 29 October 2015

Tons of Updates to Power BI in October!

There were so many updates to Power BI this month I thought I’d put all the links to the information on the updates in one place so we can get caught up quickly on everything that changed with the tool this month. Down below you’ll find my commentary on which… Read more

0 comments, 505 reads

Posted in SQL with Dustin Ryan on 29 October 2015

Tons of Updates to Power BI in October!

There were so many updates to Power BI this month I thought I’d put all the links to the information on the updates in one place so we can get caught up quickly on everything that changed with the tool this month. Down below you’ll find my commentary on which… Read more

0 comments, 286 reads

Posted in SQL with Dustin Ryan on 29 October 2015

My PASS Summit 2015 Presentation

I’m going to present my session about working with parameters in PASS Summit on Thursday at 03:15pm. The title of the session is “How to Use Parameters Like a Pro and Boost Performance”. I love this session. I cover a lot of important tips, which in many cases can turn… Read more

0 comments, 400 reads

Posted in Guy Glantser on 29 October 2015

Older posts