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

Latest Blog Posts

SQL Server on Linux, first observations.

Is this one of those weird food combinations like honey on pizza or salt and pepper on apples that’s going to split the world. My first observations of the preview are here:

A first look at SQL Server on Linux

The post SQL Server on Linux, first observations. appeared first… Read more

0 comments, 312 reads

Posted in SQLYSE with Pankaj Manek on 22 November 2016

Two Weeks to Live! 360 and VSLive Orlando

A short break in speaking, as I haven’t been on stage since Oct 11.

Now it’s two weeks to Live! 360 in Orlando and VS Live, both happening in Orlando on Dec 5-9. You can still register, and save $500 with my link.

This is my first time at… Read more

0 comments, 485 reads

Posted in The Voice of the DBA on 21 November 2016

SQL Server on Linux – How I think they did it!

OK, so everyone wants to know how Microsoft did it…how they got SQL Server running on Linux. In this article, I’m going to try to figure out how.

There’s a couple of approaches they could take…a direct port or some abstraction layer…A direct port would have been hard, basically any… Read more

2 comments, 1,656 reads

Posted in Anthony Nocentino's Blog on 21 November 2016

Query Data Store Data

The data in the Query Data Store is what makes all the magic happen. From collecting the aggregate performance metrics of a query to the various plans in use by that query to being able to force a plan, it’s all controlled by the data within the Query Data Store… Read more

1 comments, 839 reads

Posted in The Scary DBA on 21 November 2016

Reload a table quickly.

Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload. A summary table of data from the previous month, for example. It just doesn’t make sense to do an update. You delete/truncate and you re-load. Unfortunately, this leaves the table… Read more

4 comments, 1,643 reads

Posted in SQLStudies on 21 November 2016

Associative Analytics: Two sample T Test

In the previous post we looked at a one way T-Test. A one way T Test helped us determine if a selected sample was indeed truly representative of the larger population. A Two way T Test goes a step further – it helps us determine if both samples came from… Read more

0 comments, 886 reads

Posted in Mala's Data Blog on 21 November 2016

An early Christmas present - Great Value SQL Server Training the Decemeber


No No, not my new hat, although it is rather splendid. I have received the weekly email from Learning Tree listing this week’s courses that are guaranteed to run and being offered at the fantastic price of £750 plus VAT.

Happy New Hat


If you work with SQL Server this…

Read more

0 comments, 105 reads

Posted in The SQL DBA in the UK on 21 November 2016

Monday Coffee 2016-11-21

Well there were quite a few announcements in the SQL Server world last week.

SQL Server vNext CTP was made available for download, the big news there is that that version will be available either on Windows or Linux. The Linux version of SQL has been in private preview for… Read more

0 comments, 108 reads

Posted in The DBA Who Came In From The Cold on 21 November 2016

Task Manager is a liar

I remember asking a question at a recent training event, the outcome? I now don’t use task manager to try and understand how much memory SQL Server is consuming. Why? Well it has the ability to lie, and as you … Continue reading

Read more

3 comments, 294 reads

Posted in All About SQL on 21 November 2016

Columnstore Indexes – part 91 (“SQL Server 2016 Standard Edition Limitations”)

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

Given the improvements and the availability of the of the programability surface for every edition (with some insignificant & logical limitations) that I have blogged about in
SQL Server 2016 SP1 – Programmability Surface for… Read more

2 comments, 148 reads

Posted in Niko's blog on 20 November 2016

Custom indexes on VMware vCenter database breaks 6.5 upgrade

Warning! If you have added custom indexes to the VMware vCenter database, you will need to remove them completely before you can complete a vCenter 6.5 upgrade. If they are still present in the database, the upgrade wizard throws an error.

The error file tells you specifically which indexes it… Read more

1 comments, 112 reads

Posted in Technobabble by Klee from @kleegeek on 20 November 2016

Columnstore Indexes – part 90 (“In-Memory Columnstore Improvements in Service Pack 1 of SQL Server 2016 “)

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

This blog post is focusing on a very important improvement to the limitation of the In-Memory Columnstore Indexes that was existing in SQL Server 2016, but was solved in the Service Pack 1 – the… Read more

0 comments, 122 reads

Posted in Niko's blog on 20 November 2016

SQL Server 2016 SP1 Query Specific Wait Statistics Available Through Execution Plans

SQL Server 2016 SP1 added loads of cool new features and options. One of those is a change that expands the amount of information that is stored inside an execution plan. Since I love using Wait Statistics as a way to identify performance bottlenecks, I was literally jumping through the… Read more

4 comments, 1,060 reads

Posted in DotNine SQL Server and more on 20 November 2016

SQL Server 2016 - SQL Service Doesn't Start after GDR Security update

Recently, after an security fix GDR (https://support.microsoft.com/en-us/kb/3194716) on  SQL Server 2016 RTM, SQL Service refused to start. Though, the patch completed successfully as per 
"C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log", the Event viewer under "System" gave the following error

"The SQL Server (I2016) service terminated with the following service-specific…

Read more

0 comments, 191 reads

Posted in SQL and SQL Only on 20 November 2016

New home for SQL Server Citation



Change is inevitable, it's natural. I would like to quote few lines from Shrimad Bhagavad Gita says     Change is the law of the the universe.  In my opinion, change will bring good to your life, always. 

In 2004, I have started this blog, like others, this blog was started…

Read more

Power BI On Premises Integration with Reporting Services Preview

Since the Reporting Services product team announced last year that it was their intention to provide an on premises deployment option for Power BI reports, there has been tremendous interest.  Despite their determination to provide clarity around their efforts , there has still been some speculation about how and when…

Read more

1 comments, 1,657 reads

Posted in SQL Server BI Blog on 19 November 2016

Book Review: Marshmallow Test

Different people approach their career in different ways. My working assumption, all the time, is that I don’t know enough and I’m not good enough. Don’t get me wrong, I’ve got an ego (way too big of one really). I just know that there’s room for improvement. It’s one of… Read more

2 comments, 127 reads

Posted in The Scary DBA on 18 November 2016

Video: Introduction to SQL Server Change Tracking

SQL Server change tracking is a lightweight and synchronous mechanism for detecting inserts, updates, and deletes in tracked tables. For those of us who spend a lot of time in ETL, change tracking is a useful tool for defining what data has changed to make the extract-transform-load process more efficient.… Read more

0 comments, 1,068 reads

Posted in Tim Mitchell on 18 November 2016

Friday Reading 2016-11-18

Another week almost over so in-between daydreaming about relaxing this weekend I’ll be reading…

https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/
SQL Server 2016 SP1 has been released. If you haven’t read this blog post yet, have a look at the first point when it details what new in SP1

https://www.microsoft.com/en-us/sql-server/sql-server-vnext-including-Linux#resources
SQL Server vNext is out… Read more

0 comments, 119 reads

Posted in The DBA Who Came In From The Cold on 18 November 2016

Query tuning 101: How to measure Query Plan I/O cost

If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at your plan you may have noticed that each operator has a cost. Did you know that the cost is measurable?

When you’re looking at your plan where do you start?… Read more

0 comments, 2,036 reads

Posted in Confessions of a Microsoft Addict on 18 November 2016

Newer posts

Older posts