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

Latest Blog Posts

Columnstore Indexes – part 64 (“T-SQL Improvements in SQL Server 2016”)

Continuation from the previous 63 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I have decided to write a rather small blogpost, highlighting the T-SQL improvements already available in SQL Server 2016. The reason behind this blogpost is because…

Read more

0 comments, 49 reads

Posted in Niko's blog on 2 September 2015

Know About Temporal Tables in SQL Server 2016

Temporal tables were included in SQL Server 2016 as a new feature. These temporal tables are also known as system-versioned tables allow SQL Server for keeping the history of data in table automatically. A temporal table can be defined as a table for which PERIOD definition exists comprising of system… Read more

0 comments, 0 reads

Posted in Zora's SQL Tips on 2 September 2015

SQL Server Page Level Corruption And Resolution

SQL Server Page Level corruption is encountered due to several reasons, which includes hardware related issues, i.e. failure of certain hardware, hard disk functioning failure, improper network establishment, or logical level of issues such as malware intrusion on the server storing data, repository being declared as out of limit. These… Read more

0 comments, 0 reads

Posted in Zora's SQL Tips on 2 September 2015

An Evening of Networking at the 2015 PASS Summit on October 26, 2015 (Monday)

Going to be in Seattle on Monday night (Oct 26th) and want to see old friends and make some new ones? Here’s the registration link for our networking dinner/party. The location should be settled sometime in the next few days. Turns out Monday night is football night in Seattle and… Read more

0 comments, 62 reads

Posted in SQLAndy on 2 September 2015

We can do professional SQL Server deployments using SSDT

Really excited by my first post on medium, haven't really used it before but found it to be a really nice tool:

https://medium.com/@edelliott.the.agilesql.club/let-s-start-doing-profes...

Read more

0 comments, 89 reads

Posted in Ed Elliott's Sql Developer Blog on 2 September 2015

Checking for Excessive Permissions in SQL Server - WaterOx Consulting

Reading Time: 2 minutes

Who can do what? One of the key things that a DBA...

The post Checking for Excessive Permissions in SQL Server appeared first on WaterOx Consulting.

Read more

0 comments, 89 reads

Posted in WaterOx SQL on 2 September 2015

Upcoming Presentation – Space Coast SQL/.Net User Group

If you happen to be in the central Florida or Daytona area head over to Melbourne on September 10th to see me!

I’ll be speaking at the newly merged Space Coast SQL/.Net User Group on Power Query. This topic is easy for anyone in SQL, business intelligence, .Net or even… Read more

0 comments, 55 reads

Posted in Bradley Schacht on 2 September 2015

Learning Regular Expressions

I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term for me, but not something I’d ever looked at much. Well as it happens I had something that I needed to use it on a day or two later and… Read more

4 comments, 60 reads

Posted in SQLStudies on 2 September 2015

Nominated for Author of the Year 2015

I have the great pleasure to announce that I have been nominated for the “Author of the Year 2015” award at the MSSQLTips website. This means however I have to persuade people to vote for me, hence this blog post  I received the award last year, so I have a… Read more

0 comments, 52 reads

Posted in Koen Verbeeck on 2 September 2015

Viewing Deployed XEvent Metadata

Today will be the first of a few introductory level posts about Extended Events.

When dealing with Extended Events, there are a few ways to take a look some of the metadata. Not all metadata is created equal when dealing with Extended Events. Some of the metadata is pertinent to…

Read more

0 comments, 49 reads

Posted in SQL RNNR on 2 September 2015

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, 86 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, 66 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, 62 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, 129 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, 119 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, 78 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, 86 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, 109 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, 90 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, 126 reads

Posted in Koen Verbeeck on 1 September 2015

Older posts