Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Pro SQL Server Wait Statistics available now!

Remember that blog post from April this year that I announced working on my first ever SQL Server related book “Pro SQL Server Wait Statistics”? Well good news, it is available now!

Pro SQL Server Wait Statistics is available in a variety of different formats, including ePub, Kindle and paperback… Read more

0 comments, 40 reads

Posted in DotNine SQL Server and more on 2 September 2015

Monitoring of free space in database files

Monitoring of the size of database files is one of the important DBA tasks and this process should be automated. This article will show you how you can achieve this. Why is it important? Most likely you keep an eye of the size of the database and its files to… Read more

0 comments, 35 reads

Posted in Forrards Group Database Blog on 2 September 2015

10 DAX Calculations for your Tabular or Power Pivot Model (Part 1)

If you’ve read my blog for a while you may have seen the following posts:

Ten MDX Calculations For Your Cube (part 1)
Ten MDX Calculations For Your Cube (part 2)

Well the time has come for me to put together a compilation of ten useful DAX calculations for your… Read more

0 comments, 31 reads

Posted in SQL with Dustin Ryan on 2 September 2015

Better Test Data Domains with SQL Data Generator

I’ve been working more with SQL Data Generator (SDG) because it solves some problems that many software developers have with test data. Often each developer needs to create their own set of test data, with these being the common actions:

  • Use a backup of production, perhaps old.
  • Randomly insert a…

Read more

0 comments, 107 reads

Posted in The Voice of the DBA on 1 September 2015

CISL – Columnstore Indexes Scripts Library, Release 1 (“Ortus”)

I am glad to announce the very first release of the CISL – Columnstore Indexes Scripts Library, with codename “Ortus”. Go on and download the very first release to find out what it is all about. This release consists from…

Read more

0 comments, 91 reads

Posted in Niko's blog on 1 September 2015

Join Me for Free #PowerPivot Training w/ @ExcelBIPASS Sept 10 – 12p CDT

I’m excited to be able to say that coming up next week on Thursday September 10, I’ll be presenting my session Power Pivot 101: An Introduction to the PASS Excel BI Virtual Chapter! For a lot of users, Power Pivot is like the Ferrari you had in your garage but… Read more

0 comments, 61 reads

Posted in SQL with Dustin Ryan on 1 September 2015

Shredding Extended Event Actions

The other day I wrote about that torrid love/hate relationship DBAs tend to have with working with XML. In that same post, I promised I would have a follow up post about XML in Extended Events.

Well, today I present to you another opportunity for you to renew your love/hate… Read more

0 comments, 56 reads

Posted in SQL RNNR on 1 September 2015

Time for T-SQL Tuesday #70!

Here is your invitation for T-SQL Tuesday #70, and the topic is: Strategies for managing an enterprise We define “enterprise” in a number of ways, but I tend to default to two definitions: “the things I’m in charge of” and “anything I don’t want to do manually”.  In other words,…

Read more

2 comments, 89 reads

Posted in SQL Awesomesauce on 1 September 2015

How to Create Pareto Chart in Power BI

About 80% of the world’s population lives in about 13% of the countries. Okay, this statement is not as knee-jerking as I made it sound. Pareto Principle (also known as 80-20 rule, the law of the vital-few) states that, for many events, roughly 80% of effects come from 20% of… Read more

0 comments, 64 reads

Posted in Sam Vanga on 1 September 2015

SQL 2016 CTP 2.3 has been released

A new monthly release of the SQL Server 2016 preview has been released: CTP 2.3.
You can find the download here (the official SQL Server 2016 page currently still links to CTP 2.2).

There isn’t any official documentation out yet describing which features have been added or improved, but thanks… Read more

0 comments, 98 reads

Posted in Koen Verbeeck on 1 September 2015

CONTEXT_INFO and efficient mass update on a large table with a trigger

Let`s assume we have following task – make changes to the data in a large table that has consistency checker in a trigger. Let`s look at the ways to do it in a most efficient way.

Use test database in a simple recovery mode. Create two tables and fill them… Read more

0 comments, 61 reads

Posted in Forrards Group Database Blog on 1 September 2015

Experiences of Submitting a PASS 2015 Session

The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or so selected to speak at the conference (…and as a quick aside I also note a reasonably… Read more

0 comments, 76 reads

Posted in Mr. Fox SQL on 31 August 2015

Upgrading a SQL Azure Database to v12

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I was looking to test some of the Azure v12 capabilities, but I needed to upgrade a database. Here’s a quick look at how.

In the old portal,… Read more

0 comments, 98 reads

Posted in The Voice of the DBA on 31 August 2015

Populating My DBA Database for Power Bi with PowerShell – Server Info

Following my last post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database. They are the secondary part to my DBADatabase which I also use to automate the installation and upgrade of all… Read more

0 comments, 79 reads

Posted in SQL DBA With A Beard on 31 August 2015

SSC Editorial: The Problem Solver

The Problem Solver. Ever scoffed at personality types? Surely none of us are just one thing, but often we are mostly one thing, or at least one thing that is easily identified as being a big part of who we are. Writing this I was thinking about two things… Read more

0 comments, 92 reads

Posted in SQLAndy on 31 August 2015

The default instance has a name

The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but hold on because I’m going to go a little bit deeper. When we connect to a default instance we typically just put down the server name right? Is that because… Read more

2 comments, 88 reads

Posted in SQLStudies on 31 August 2015

Your presentation matters! Do it right!

This weekend I was invited over at SQLSaturday Oslo to speak about SQL Server Indexing. I ran into Boris Hristov there and we ended up in a discussion about presentation design, and how it plays a huge role in getting your message across to your audience. As a speaker myself,… Read more

0 comments, 79 reads

Posted in DotNine SQL Server and more on 31 August 2015

Buffer Pool Extension in SQL Server 2014 part 2: benchmark testing

Let’s take a closer look at how we can speed up the system’s performance using the Buffer Pool Extension. For testing I will use a virtual machine with 4 GB RAM. I created a separate database with one table. The table has 2 columns [id] and [n]. The first column… Read more

0 comments, 100 reads

Posted in Forrards Group Database Blog on 31 August 2015

At SQL Server Geeks 2015 - Pre Conference Session - Benjamin Nevarez

Attended SQL Server Geeks Annual Summit 2015 on last Wednesday (26/8) at Bangalore, India. Due to few urgent responsibilities at work, could attend only Pre Conference event on Wednesday, skipping the events on Thursday, Friday and Saturday.

The Preconference event I attended was "SQL Server Optimization and Tuning" by Benjamin…

Read more

0 comments, 82 reads

Posted in SQL and SQL Only on 31 August 2015

Dimensional Modelling in Lucidchart vs Visio: Part 1

Data modelling is a pivotal skill that every practitioner in data management should acquire. That said, there are numerous tools that can be used to model data. As a Certified Microsoft Professional, my default modelling tool has always been Microsoft (MS) Visio and sometimes, Visual Studio. However, I’ve… Read more

0 comments, 102 reads

Posted in Select SIFISO Blogs on 30 August 2015

Older posts