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

Archives: December 2015

Top 10 Enhancements to Azure SQL Database in 2015

Top 10 Enhancements to Azure SQL Database in 2015
DECEMBER 27, 2015

Introduction
2015 has been a massive year for Azure SQL Database. This year has seen the product mature from "an interesting idea" and "something that we should have a look at" to a genuine piece of enterprise software…

Read more

0 comments, 750 reads

Posted in Pie in the Sky on 27 December 2015

Type 6 or Hybrid Type 2 Slowly Changing Dimension with Biml

In my previous post, I provided the design pattern and Biml for a pure Type 2 Slowly Changing Dimension (SCD). When I say “pure Type 2 SCD”, I mean an ETL process that adds a new row for a change in any field in the dimension and never updates… Read more

1 comments, 268 reads

Posted in Data Savvy on 27 December 2015

Columnstore Indexes – part 75 (“Stretch DB & Columnstore”)

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

This blog post focuses on one of the newest additions to SQL Server 2016, the feature that most probably has gained a universal appraisal since the announcement – the Stretch DB and its integration with… Read more

2 comments, 360 reads

Posted in Niko's blog on 26 December 2015

Learn How to Insert Data From Stored Procedure Into Table?

Stored Procedures are considered most efficient way for calling and retrieving data and hence users always look forward to encapsulate logic in it so that it can be called when needed. While encapsulating data in Stored Procedure, it is also important to know how to retrieve data they return. Now,… Read more

0 comments, 501 reads

Posted in PowerSQL By Prashanth Jayaram on 26 December 2015

Bad queries!!!

Once it happend quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and worst. The average CPU raised over 80% (Figure 1) and we started to settle bad made things, but the situation went worst - 100% CPU as in the…

Read more

0 comments, 45 reads

Posted in SQL Mighty on 25 December 2015

How a Bad query can rise up your CPU to ceiling

Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and worst. The average CPU raised over 80% (Figure 1). I just captured the moment and want to share.

Figure 1. Very high CPU on a 24 core with 128GB RAM

One… Read more

0 comments, 26 reads

Posted in Si vis pacem, para sql on 25 December 2015

Columnstore Indexes – part 74 (“Row Group Merging & Cleanup, SQL Server 2016 edition”)

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

Row Group merging & cleanup is a very long waited improvement that came out in SQL Server 2016. Once Microsoft has announced this functionality, everyone who has worked with SQL Server 2014 & Clustered Columnstore… Read more

2 comments, 483 reads

Posted in Niko's blog on 25 December 2015

Closing Down for the Year

Today is my last day of work for 2015. I’m actually proud that I’ve managed to take almost all my vacation (3 days left), and will be enjoying myself next week with my family, taking our holiday vacation in the mountains.

It’s been quite a year for me. Lots of… Read more

0 comments, 533 reads

Posted in The Voice of the DBA on 24 December 2015

Advent of Code – Day 4

Day 4 of the Advent of Code has us mining for data in MD5 hashes, which is out of the comfort zone for a SQL DBA to say the least.

Some would say it’s a poor use for SQL Server, and I’d have to agree.  However, sometimes things just need… Read more

1 comments, 412 reads

Posted in Simple SQL Server on 24 December 2015

Advent of Code – Day 3

Continuing with the language-independent code challenge on Advent of Code – Day 3, I’m tasked with figuring out how well a drunken elf can guide Santa to houses.  Since his instructions had Santa stumbling into the same house multiple times they then added in a robot to help Santa… Read more

2 comments, 358 reads

Posted in Simple SQL Server on 24 December 2015

Thoughts on Advent of Code

Over the past couple of days I’ve posted several times about the Advent of Code Contest and worked my way through the first three puzzles, now I’d like to share some thoughts about how it works and what I’ve learned so far:

  • The site is well done. Simple to use…

Read more

0 comments, 581 reads

Posted in SQLAndy on 24 December 2015

SQL Server 2016 AlwaysOn Availablility Enhancements


In this Article I have listed out SQL Server 2016 AlwaysOn Availability Enhancements.
SQL Server 2016 [CTP 3.2] SQL Server 2016 CTP Standard Edition now supports AlwaysOn Basic Availability Groups.
AlwaysOn Basic Availability Groups replaces the deprecated Database Mirroring feature for SQL Server 2016 Standard Edition. 
AlwaysOn Basic Availability Groups provide a…

Read more

0 comments, 81 reads

Posted in Ganapathi's MSSQLLover on 24 December 2015

Specifying Paths to External Items (Report Builder and SSRS) in SharePoint with PowerShell

[2015-Dec-24] My story: two SSRS items (main report and its sub-report) need to be deployed to SharePoint. Trivial task, and even if I need to locate sub-report to a different SharePoint document library or folder I can easily do that during a development phase or using Report Builder…

Read more

1 comments, 965 reads

Posted in Data Adventures on 24 December 2015

Advent of Code #3 – Part 2

Adding to my solution for #3 part 2, I finally got it, but I paid the price for not adding the “0, 0” to the data set and just assumed I should add one. Bad assumption! Wound up being off by 1 and it took too long to figure that… Read more

0 comments, 550 reads

Posted in SQLAndy on 23 December 2015

Advent of Code #3 – Part 1

Part 1 isn’t bad. Parse a string that has direction indicators and track each location you stop at. I’m trying to do one more today and running out of time, so I hurried to a solution that works, but will just suck when I get to part 2 of #3… Read more

0 comments, 816 reads

Posted in SQLAndy on 23 December 2015

Advent of Code #2

This one gives you a 1000 rows of package dimensions. You calculate the surface area needed for wrapping paper, plus some ‘slack’ that is the area of the two smallest dimensions. The first part is easy, the second – how do you figure out the two smallest numbers when represented… Read more

0 comments, 527 reads

Posted in SQLAndy on 23 December 2015

Back to Basics: Why not parameterize?

I think sometimes those of us that have been doing database administration/development for a while take it for granted that everyone knows the basics. One such basic is parameterizing stored procedures. This allows us to potentially consolidate multiple stored procedures into a single procedure.  It’s as simple thing to do… Read more

0 comments, 104 reads

Posted in SQLEspresso on 23 December 2015

CISL Roadmap

The year 2015 is coming to an end and I wanted to publish my currently planned roadmap for the CISL – Columnstore Indexes Scripts Library in 2016.

The current version is 1.0.4 but here you can already see what I am planning for the next months

Version 1.1 – The… Read more

0 comments, 326 reads

Posted in Niko's blog on 23 December 2015

Advent of Code

If you want your skills to be sharp, you practice.  If you want to get yourself to actually do practice, you call it a “challenge”.  This is what the Advent of Code is.

Now let me be perfectly clear about how I feel about practice.  I saw Jeremiah’s (b Read more

8 comments, 1,360 reads

Posted in Simple SQL Server on 23 December 2015

‘Twas 4:45 Friday

I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents so here is my Christmas post from last year.  Enjoy :)

‘Twas 4:45 Friday, and all through the office
not a creature was stirring, not even the bosses.
The code… Read more

0 comments, 381 reads

Posted in SQLStudies on 23 December 2015

Newer posts

Older posts