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

Latest Blog Posts

Getting a VHD into Azure with PoSh

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

I thought this would make a nice SQLNewBlogger post, an easy get started one. I used the docs from Microsoft as a guide, so here’s how it… Read more

0 comments, 19 reads

Posted in The Voice of the DBA on 27 March 2017

sp_SrvPermissions & sp_DBPermissions V6.0 Finally!

It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well, I’m sure all of you have been holding your collective breath but I finally have some new updates. I’m particularly excited about the @DropTempTables and @Output options.

Just as a… Read more

0 comments, 41 reads

Posted in SQLStudies on 27 March 2017

Custom keyboard shortcuts in SQL Server Management Studio (SSMS)

People love taking shortcuts because it’s the easiest way to do things faster; computers are no exception. Shortcuts, particularly ones performed by keyboard, can save you hours of time once applied properly. Learning keyboard shortcut saves you a lot of time; you’ll definitely notice a boost the productivity because you’re… Read more

0 comments, 46 reads

Posted in PowerSQL By Prashanth Jayaram on 27 March 2017

Orlando Code Camp 2017

I’ll be attending and speaking at Orlando Code Camp  on April 8th. Come by and say hello if you’re attending, maybe we can talk career paths, security, or devops for dbas!


Read more

0 comments, 58 reads

Posted in SQLAndy on 27 March 2017

Reading the January 2017 PASS Minutes

I’ve been catching up on stuff this week, including reading the January 2017 minutes. It was in-person meeting so a lot was covered. I don’t want to summarize it, you should read it, but there were some trends I noticed I wanted to comment on:

  • Goals are frequently mentioned, but…

Read more

0 comments, 63 reads

Posted in SQLAndy on 27 March 2017

Reviewing the PASS 2017 Budget

I did a quick review of the 2017 PASS Budget. It’s not a page turner, but it has a lot of good information. I wish there as more context about some of the changes. The following isn’t a summary, just notes about areas I either care about or caught… Read more

0 comments, 50 reads

Posted in SQLAndy on 27 March 2017

Test your Sqlserver backups on Linux with PowerShell and dbatools

I have written about Test-DbaLastBackup in posts here, here and here. They have been Windows only posts.

With SQL Server vNext CTP 1.4 now available and providing SQL Agent capability on Linux, I wrote here about using Ola Hallengrens scripts on Linux SQL Servers so can Test-DbaLastBackup work… Read more

0 comments, 47 reads

Posted in SQL DBA With A Beard on 27 March 2017

SQLBits 2017

I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which is just over a week away. The Data Platform has evolved so much and this is the chance to get … Continue reading

Read more

0 comments, 52 reads

Posted in All About SQL on 27 March 2017

Monday Coffee 2017-03-27

Hey all, I’m back after attending SQL Saturday in Iceland. This week’s going to be busy!

I’ve said before that SQL Saturday Iceland was the first time that I presented a full hour session. It seemed to go well although having it start at 14:50 wasn’t the best as I… Read more

0 comments, 44 reads

Posted in The DBA Who Came In From The Cold on 27 March 2017

How easy it is to implement Row Level Security in SQL SERVER 2016 ?

To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first.
Problem 1 Suppose, you have a Multi-tenant e-commerce website and different companies registered on your website and you have centralized single database for all the client. Now as a product owner it is your responsibility that one tenant’s…

Read more

0 comments, 46 reads

Posted in Rajat Jaiswal-337252 on 27 March 2017

How easy to implement RLS (Row Level Security) in SQL SERVER 2016 (New Feature)

To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first.
Problem 1 Suppose, you have a Multi-tenant e-commerce website and different companies registered on your website and you have centralized single database for all the client. Now as a product owner it is your responsibility that one tenant’s…

Read more

0 comments, 56 reads

Posted in Zora's SQL Tips on 27 March 2017

Columnstore Indexes – part 100 (“Identity”)

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

In Data Warehousing one will not be shocked to find a number of tables using IDENTITY property on a column, a lot of times to create automatic incremental values for the surrogate keys.
What about… Read more

2 comments, 141 reads

Posted in Niko's blog on 25 March 2017

The Public Speaking Roadmap

So you look around, and all the cool kids are speaking at SQL Saturdays and PASS Summit and the like. You want to be the cool kids too, so how do you start public speaking? Here in four simple steps, is your roadmap.

The post The Public Speaking Roadmap appeared… Read more

0 comments, 70 reads

Posted in SQL Awesomesauce on 25 March 2017

Using Pester with dbatools Test-DbaLastBackup

In previous posts I have shown how to use Test-DbaLastBackup from dbatools and how you can make use of the results. Today we will look at using  Pester with the results

Pester provides a framework for running unit tests to execute and validate PowerShell commands from within PowerShell.…

Read more

1 comments, 93 reads

Posted in SQL DBA With A Beard on 25 March 2017

TSQLTuesday.com – Quick WordPress Setup in Azure

When I agreed to host the T-SQL Tuesday site, I wasn’t sure what to do. I thought about just putting up a static page, one I’d edit, but in some conversations with Adam Machanic, he wanted to have a few people able to manage the site. That makes sense and… Read more

1 comments, 538 reads

Posted in The Voice of the DBA on 24 March 2017

Querying SQL and Windows Version Info with T-SQL

Just a quick one today - I see questions sometimes about polling Windows information from inside SQL Server itself.  There are a couple of frequently touted options:


--


(1)  SELECT @@VERSION


The most basic option, and it does return most of what we want but not in any kind of…

Read more

0 comments, 152 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 March 2017

A Note on Configuring HP SSD’s

Sharing this without a supporting link, might help someone. During a recent move from SAN to local SSD the storage guy noted that the following has to be done to get best performance.

This command disables SSD Smart Path. You must disable the SSD Smart Path before enabling Controller caching.…

Read more

0 comments, 96 reads

Posted in SQLAndy on 24 March 2017

Why did my SQL Server database just go offline?

Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely use SQL Server Management Studio GUI to do day-to-day tasks, I rather just load a window and start typing stuff … Continue reading

Read more

0 comments, 167 reads

Posted in All About SQL on 24 March 2017

Configuring KDIFF With GitHub

Posting this mostly in case I need it again. I needed a merge tool for Git, Kdiff is free and useful, but you have to get all the switches set up if you want full functionality (three way merge). I found the answer on this blog post (a reminder to… Read more

0 comments, 94 reads

Posted in SQLAndy on 23 March 2017

vNext has AG

Now vNext SQL Server on Linux supports Availability Group HA/DR functionality supported.   https://blogs.technet.microsoft.com/dataplatforminsider/2017/02/17/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups/    

Read more

0 comments, 92 reads

Posted in Vinay Thakur on 23 March 2017

Older posts