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

Archives: June 2017

Persisting data in docker containers – Part Two

Last week in Part One I went through how to mount directories from the host server into a docker container in order to persist data.

However, you don’t have to do this in order to share volumes between containers. Another method is to create named volumes within the docker ecosystem… Read more

1 comments, 1,359 reads

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

The Three A’s: Authorization

Having covered authentication yesterday, let’s move on the second A, authorization. Authentication was about proving identity. Now that we know that identity, we can determine permissions. Just because we have authentication doesn’t mean we have authorization. Let me give you an example. 

A club only permits patrons who are 21… Read more

0 comments, 1,580 reads

Posted in Databases – Infrastructure – Security on 27 June 2017

My SQL Server Development Toolbox

Having the right tools for the job makes the work much more efficient. However, for those just starting out in SQL Server land, it may not be clear which tools are useful or appropriate for a given task. I regularly field questions about which tools I use on my development… Read more

9 comments, 2,285 reads

Posted in Tim Mitchell on 27 June 2017

Using SQL Server Diagnostics (Preview)

I was VERY excited when I read the following tweet (below) from Bob Ward regarding SQL Server Diagnostics capability. What is it you are asking? It is an extension to SQL Server Management Studio (SSMS) where it gives you the ability to Upload / Analyse dump files created by SQL… Read more

9 comments, 481 reads

Posted in All About SQL on 27 June 2017

Overview of Resumable Indexes in SQL Server 2017

Managing indexes is a critical component of database maintenance but we often don’t think about the indicators behind the index maintenance operations. SQL Server 2017 (CTP 2.0) introduces a very useful index feature, to mitigate the administration overhead of index maintenance which we’ll review and discuss in this article. Read more

0 comments, 486 reads

Posted in PowerSQL By Prashanth Jayaram on 26 June 2017

Adding Performance Counters back for SQL Server

I had a strange situation the other day, where a number of things went wrong with my instance. First, I lost permissions to detached databases. The SID was listed in the file permissions, but apparently unlinked to an account.

Next, I went to add an alert, and I only had… Read more

0 comments, 521 reads

Posted in The Voice of the DBA on 26 June 2017

Database Fundamentals #4: Create a Database

SQL Server provides multiple ways to perform most functions. In order to maximize your understanding of how SQL Server works and have as many different mechanisms as possible for getting work done, you’ll use the GUI and TSQL to learn how to create and drop databases. You can then use… Read more

2 comments, 1,849 reads

Posted in The Scary DBA on 26 June 2017

Temp table quiz

Brent Ozar (b/t) posted a pop quiz on twitter earlier today.

Go ahead and give it a shot .. I’ll wait.

So? What do you think? Did you get it right? I did, but I wasn’t 100% certain, nor did I initially think through all of… Read more

10 comments, 562 reads

Posted in SQLStudies on 26 June 2017

Keep VMware snapshot growth from wrecking your day

VM snapshots are one of the best virtualization features ever. But…have you ever had a VMware vSphere or Hyper-V snapshot grow out of control and fill the datastore the VM resides on? You know what happens… even the best VM admins out there seem to get burned once when they… Read more

1 comments, 1,289 reads

Posted in Technobabble by Klee from @kleegeek on 26 June 2017

SQLpassion Workshops for Fall 2017

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Time goes by, and today I’m very proud to announce all upcoming SQLpassion workshops for the second… Read more

0 comments, 161 reads

Posted in Klaus Aschenbrenner on 26 June 2017

Real-life SQL Server Performance Troubleshooting at SQLSaturday Columbus

Join me Friday, July 21, 2017 for a day of Real-life SQL Server Performance Troubleshooting as part of SQLSaturday Columbus at Otterbein University Campus Center in Columbus, OH. Register for SQLSaturday Columbus before it fills up, and check out the early bird pricing for the pre-conference sessions the day before.…

Read more

The Three A’s: Authentication

When I start talking with folks about security, one of the areas of confusion I often find has to do with the three A’s of security. Specifically, the difference between the first two: authentication and authorization. Let’s look at the first today. 

Authentication is simply proving who you are. With… Read more

0 comments, 1,717 reads

Posted in Databases – Infrastructure – Security on 26 June 2017

Monday Coffee: Attending Conferences

Last week I asked the following question on Twitter: –

I was interested to see the responses as I wanted to know how more experienced presenters get the time off to speak at so many events. Up until now I’ve been using annual leave and this was a way of… Read more

4 comments, 271 reads

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

External Tool VSCODE called from SQL Management Studio

Previous Related Post: Split personality text editing in SSMS with Sublime Text 3

In this prior post I wrote about how to call Sublime Text 3 from SSMS to allow improved text manipulation to be quickly called from an active query window in SQL Management Studio. Vscode is a newer… Read more

0 comments, 328 reads

Posted in Sheldon Hull on 26 June 2017

SQL Server Database Files Wise I/O Latency Details PART#1

One of the real-world I/O troubleshooting problems is – If you have your databases spread across multiple LUNs and you want to find out which database files are experiencing high latency issues and driving the most I/Os to storage subsystem using performance counter (Avg. Disk sec/Read & Avg. Disk sec/Write).… Read more

4 comments, 2,511 reads

Posted in SQL Geek on 26 June 2017

Geo Location of Twitter messages in Power BI

[2017-June-25] There are several custom solutions that make Twitter messages analysis possible in Power BI. And with a recent addition of the Campaign/Brand Management for Twitter solution template for Power BI (https://powerbi.microsoft.com/en-us/solution-templates/brand-management-twitter/) it's getting even less complicated to get into this social media mainstream data exploration.

Here is…

Read more

4 comments, 1,738 reads

Posted in Data Adventures on 25 June 2017

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, 465 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, 1,531 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, 590 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, 318 reads

Posted in Anthony Nocentino's Blog on 23 June 2017

Newer posts

Older posts