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

Latest Blog Posts

Columnstore Indexes – part 107 (“Dictionaries Deeper Dive”)

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

I would like to thank Sunil Agarwal (Program Manager) & Vassilis Papadimos (Software Engineer) for all their patience and explanations, helping me to get to the bottom of the faced issues and delivering me a… Read more

0 comments, 52 reads

Posted in Niko's blog on 25 June 2017

Reflecting on the Last Year of Microsoft’s OpenSource Technologies

This past year has certainly been interesting in the world of Linux. Microsoft has taken a new strategy and is embracing the open source model. It’s releasing it’s key software products with versions for Linux. It’s truly a remarkable time. In this post I want to highlight some of the… Read more

0 comments, 104 reads

Posted in Anthony Nocentino's Blog on 24 June 2017

Speaking at 24 Hours of PASS – PASS Summit 2017 Preview

I am glad to share that I will be speaking at 24 Hours of PASS – PASS Summit 2017 Preview that will take place on 19th & 20th of July 2017.

As I already announced before, I will be delivering a precon at PASS Summit 2017 and now to promote… Read more

0 comments, 351 reads

Posted in Niko's blog on 24 June 2017

Speaking at SQLSaturday Sacramento – 650!

Speaking at SQLSaturday Sacramento!

I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 15th 2017! And wow, 650 SQLSaturdays! This one won’t let you down. Check out the amazing schedule!

If you don’t know what SQLSaturday is, it’s a whole day of free…

Read more

0 comments, 103 reads

Posted in Anthony Nocentino's Blog on 23 June 2017

#SQLChat on Performance Issues

Twitter can often be a great source of information for the SQL Community, especially with the #SQLHelp hashtag. Another resource that not everyone is familiar with is #SQLChat, which Idera runs periodically. There are moderators that helps keep things going, including at least one person from the SQL Server community,… Read more

0 comments, 102 reads

Posted in Databases – Infrastructure – Security on 23 June 2017

Loading All CSV Files with PowerShell

I ran across Denis Gobo’s post about working with names from Social Security cards and wanted to play with the dataset. However, rather than use xp_cmdshell, which I might have, I decided to use PowerShell. I need to repeat this with Python, but for now, this worked.

There is a… Read more

1 comments, 143 reads

Posted in The Voice of the DBA on 23 June 2017

Conditionally Retry a Failed Job

We have jobs that run in the early morning to load data to our data warehouses and other systems, and if they don’t complete correctly, we start to have issues that ripple through the day. In the past, we had a service provider that would monitor our jobs and rerun… Read more

0 comments, 86 reads

Posted in WaterOx SQL on 23 June 2017

Friday Reading 2017-06-23

The weather has been absolutely boiling here in Dublin all week, I’m dying for a cold beer! Anyway, whilst drinking beer I’ll be reading…

Docker Basics Webinar Q&A: Understanding Union Filesystems, Storage & Volumes
Webinar (with transcript) going into the storage concepts behind docker containers

Continuous Delivery to Microsoft Azure… Read more

0 comments, 134 reads

Posted in The DBA Who Came In From The Cold on 23 June 2017

A Big July Planned in Baton Rouge

Three big events planned in Baton Rouge this year that everyone can be a part of:

User Groups Networking Night at the Louisiana Technology Park on July 12

Attendees from all Baton Rouge User Groups (SQL Server, .NET, Power BI, IT Pro, SharePoint, and Women in Technology, students, and the…

Read more

0 comments, 164 reads

Posted in SQL Tact on 23 June 2017

1 year of blogging

It’s hard to believe but a full year has now passed as of today. It’s my blogoversery! Can that be a word? Someone hash tag it please.

To date, I have just under 15,000 views and have touched 112 countries around the world! I couldn’t be more excited and wanted… Read more

2 comments, 141 reads

Posted in Confessions of a Microsoft Addict on 22 June 2017

Move a Stored Procedure to a New Schema–SQLNewBlogger

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

One of the things I needed to do recently was move an object. I was testing the WideWorldImporters database and created an object in the dbo schema.… Read more

0 comments, 161 reads

Posted in The Voice of the DBA on 22 June 2017

VSCode – PowerShell extension 1.4.0 new command Out-CurrentFile

Yesterday David Wilson announced version 1.4.0 of the PowerShell extension for VSCode

He also pointed out that there have been over 1 million… Read more

0 comments, 203 reads

Posted in SQL DBA With A Beard on 22 June 2017

Blog Series: Cloud “Fear” Busting

I have decided to do a 4-part series on Cloud “Fear Busting” scenarios. Why? Over the past few years working with the cloud (Azure) I have come across 4 main “fears” or “concerns” that stand out in my mind that … Continue reading

Read more

0 comments, 146 reads

Posted in All About SQL on 22 June 2017

How to Automate Processing of Azure Analysis Services Models

I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache for some data in an Azure Data Warehouse instance. One of the things I’ve been working on is scheduling the automatic processing of the Azure AS database. I did find… Read more

1 comments, 228 reads

Posted in SQL with Dustin Ryan on 21 June 2017

Combating SQL Injection

Target. Home Depot. NASA. U.S. Army. Anthem. Wall Street Journal. MarketWired. Ashley Madison. What do they all have in common? They are all recent victims of cyber-attacks – several of these are confirmed to involve SQL Injection. Even though the exact method used to penetrate the other systems has not… Read more

0 comments, 235 reads

Posted in A Discussion of SQL Server-Related Topics on 21 June 2017

Working on my Microsoft Professional Program for Data Science

Microsoft announced a new program last year to help you understand the skills that a Data Scientist needs in their daily life.  It consists of nine courses and a final project, you can get all the details about it on the Microsoft Academy site.  I started working on this at… Read more

0 comments, 235 reads

Posted in SQL Swimmer on 21 June 2017

Azure DevTest Labs

I have been working at Microsoft now for 3 years and 4 months (side note: it’s by far the best company I have ever worked for).  You would think by now I know about every Azure product, but we release new products and services at such a tremendously fast pace… Read more

2 comments, 203 reads

Posted in James Serra's Blog on 21 June 2017

9003 is a Scary Number

Recently I moved up to the next consecutive error number, a 9003 error:

Log Name:      Application
Source:        MSSQLSERVER
Date:          6/15/2017 4:49:59 AM
Event ID:  …

Read more

0 comments, 201 reads

Posted in Nebraska SQL from @DBA_ANDY on 21 June 2017

Dynamically generate the command line DMA statement for each database

If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run the DMA (Database Migration Assistant). If you are doing a BUNCH of upgrades at once (say 100 instances or something) then you probably don’t want to use the… Read more

0 comments, 220 reads

Posted in SQLStudies on 21 June 2017

Using OPENROWSET in SQL Server on Linux

I wanted to import the million song dataset in SQL Server on Linux. There’s a github repo that has the SQL to allow you to use this with the graph database features. However, it’s built for Windows.

Linux is a slightly different beast. Once I started down this path, I… Read more

1 comments, 289 reads

Posted in The Voice of the DBA on 21 June 2017

Older posts