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

Latest Blog Posts

Here I go again

About two years ago I wrote my first blog post.

About a year ago I paused my blogging activity. That’s when I joined Microsoft.

Not that Microsoft forbids its employees to be active in any social networks, quite the contrary. There are however policies and rules to follow. And it… Read more

0 comments, 78 reads

Posted in Gorandalf's SQL Blog on 21 March 2017

Building a Database DevOps Process at the Data Platform Summit 2017

I’m heading to India this August for the Data Platform Summit 2017. I am honored to have been selected to deliver a pre-conference seminar called “Building a Database DevOps Process”, where I’ll walk through the way in which you can include your database alongside application code and deploy it… Read more

2 comments, 135 reads

Posted in The Voice of the DBA on 21 March 2017

The Pen Cap

This post is for all you up and coming data professionals out there. Over the course of the last week we had a T-SQL Tuesday block party which I missed. The beginning of the year is a very hectic time at the shop; doesn’t negate the fact that I… Read more

0 comments, 70 reads

Posted in The SQL Professor on 21 March 2017

Always on\Database Mirroring Automatic Page Repair

A special thanks to Daniel Jones [daniel.jones.0543@gmail.com] for showing up interest and writing informative article for our blog (http://mssqlfun.com/).

 

Always on\Database Mirroring Automatic Page Repair

One of the most useful as well as hottest feature in SQL Server is mirroring of database. It is helpful for numerous of… Read more

0 comments, 93 reads

Posted in MSSQLFUN on 21 March 2017

SSIS Articles on SQLShack

Please check out SQLShack.com for three articles on SSIS. I wrote them based on using the SSIS Catalog and Project Parameters created in SQL Server 2012 and improved on in the next 2 releases. Project parameters are a big deal in SSIS for changing values when executing a package… Read more

0 comments, 74 reads

Posted in The Smiling DBA on 21 March 2017

Power BI Custom Visuals Class (Module 43 – Gantt)

In this module you will learn how to use the Gantt Power BI Custom Visual.  Using the Gantt chart you can easily visualize project timelines and deliverable completion.

Module 43 – Gantt

Downloads

Read more

0 comments, 94 reads

Posted in Devin Knight on 21 March 2017

UK Budget 2017 – The Death Knell for Small Business?

Well I suspect not however I suspect it will likely have a major impact. What has this got to do with SQL and Data I hear you ask? I’m going to provide a little background first. Over the last week or so it has been an interesting political week here…

Read more

0 comments, 112 reads

Posted in The SQL DBA in the UK on 21 March 2017

The parts of an object’s name

Any object within a database in SQL Server has what is called a four part name. Which rather implies four pieces right? Simple enough

Server.Database.Schema.ObjectName

And you can find the lists of each of those pieces in

 
The breakdown is nice but how about usage?… Read more

0 comments, 94 reads

Posted in SQLStudies on 20 March 2017

Webinar with Pure Storage Mar23 2pm Eastern

On Thursday, March 23rd, at 2pm Eastern, I will be hosting a webinar with Argenis Fernandez from Pure Storage where we will talk about infrastructure challenges as organizations start to adopt SQL Server’s in-memory features, such as In-Memory OLTP and Columnstore Indexes.

Details: The in-memory features that accompany modern… Read more

0 comments, 80 reads

Posted in Technobabble by Klee from @kleegeek on 20 March 2017

Backup and Restore Strategies in SQL Server : A Brief Introduction

Establishment of a successful business requires the proper maintenance of the data. SQL Server is one the popular platform for the same. In SQL Server, a proper strategy has been introduced for the management of data. The Main reason of introducing SQL Server backups and restore strategies in SQL Server…

Read more

1 comments, 119 reads

Posted in Ganapathi's MSSQLLover on 20 March 2017

SQL 2016 – Clone Database with Query Store

This is a quickie post to introduce the new DBCC command CLONEDATABASE.

Okay so this isn’t technically a SQL Server 2016 only feature as it’s also available in SQL 2014 SP2 onwards – but that wasn’t released until July 2016.

CLONEDATABASE allows you to do something you could only do… Read more

0 comments, 117 reads

Posted in Matthew McGiffen DBA on 20 March 2017

Why Before How

I’ve spent a lot of time browsing and participating in online technical forums. In my early years in the industry I asked a lot of questions, and as my skills grew I evolved to the point where I was answering more questions than I was asking. The questions and answers… Read more

4 comments, 132 reads

Posted in Tim Mitchell on 20 March 2017

Basics of Probability

In this post am going to introduce into some of the basic principles of probability – and use it in other posts going forward. Quite a number of people would have learned these things in high school math and then forgotten – I personally needed a refresher. These concepts are… Read more

0 comments, 93 reads

Posted in Mala's Data Blog on 20 March 2017

Testing Your SQL Server Backups the Easy Way with PowerShell & dbatools

In a previous post I wrote about how easy it was to restore a whole SQL Servers user databases from a  directory using the dbatools module. Maybe it is a good idea to look at for disaster recovery scenarios but even PowerShell is going to be useless if your backups… Read more

3 comments, 162 reads

Posted in SQL DBA With A Beard on 20 March 2017

TDE: Looking inside your database and backups

TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too. I fancied looking inside the MDF and a backup of my database before enabling TDE and comparing it to … Continue reading

Read more

1 comments, 106 reads

Posted in All About SQL on 20 March 2017

Restoring an entire SQL Server user databases with PowerShell using dbatools

All the good DBAs backup their databases.

A significant amount of SQL DBAs use Ola Hallengrens maintenance solution to do so.

This gives a folder structure like this

 

In my lab I had installed SQL 2016 on a server running Server 2016 TP5 which expired so I needed to… Read more

1 comments, 138 reads

Posted in SQL DBA With A Beard on 18 March 2017

An Introduction to SQL Server 2016 Query Store

By David Postlethwaite

David is delivering a talk An Introduction to SQL Server Query Store at SQL Saturday Iceland today - this post has been scheduled to coincide with his talk

If you are at SQL Saturday Iceland today go and see his session.

There will be a series of…

Read more

0 comments, 181 reads

Posted in The SQL DBA in the UK on 18 March 2017

SQL Bits in less than a month

I’m getting excited, and you should as well. Join me at a fantastic conference in the UK this spring. Register today and come to a training day and learn something. I might just see you there, as I’m thinking to take one or two myself.

I’ll be presenting “Including Your… Read more

0 comments, 157 reads

Posted in The Voice of the DBA on 17 March 2017

Schedulers To Rule Them All

Sometimes things just don’t make sense.

One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled.  This results in 32 physical cores or 64 logical cores.  Therefore, this particular server should have 4 NUMA nodes available.

However, I was looking at the dashboard for… Read more

3 comments, 205 reads

Posted in John Morehouse | Sqlrus.com on 17 March 2017

SQL Server: DBCC CHECKDB Command with Complete Explanation

SQL Server is used widely for the management of database. It is possible that the data gets corrupt due to different reasons. Therefore, to deal with this issue SQL Server has a command, which act as a manual solution for corruption of the database. This command is referred as DBCC…

Read more

0 comments, 268 reads

Posted in SQL Mighty on 17 March 2017

Newer posts

Older posts