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

Archives: January 2018

Importing GeoJSON Earthquake Data Into SQL Server

A significant portion of Yellowstone National Park sits on top of a supervolcano.  Although it’s not likely to erupt any time soon, the park is constantly monitored for geological events like earthquakes.

This week I want to take a look at how you can import this earthquake data, encoded… Read more

0 comments, 13 reads

Posted in Bert Wagner on 16 January 2018

Using the AST in Pester for dbachecks

TagLine – My goal – Chrissy will appreciate Unit Tests one day

Chrissy has written about dbachecks the new up and coming community driven open source PowerShell module for SQL DBAs to validate their SQL Server estate. we have taken some of the ideas that we have presented about a… Read more

0 comments, 71 reads

Posted in SQL DBA With A Beard on 15 January 2018

SQL Server on Linux Series: Expanding LVM Drives

Next in our SQL Server on Linux series is one important question. On Windows, if you’re about to run out of space, you get your VM admin / storage admin to expand one or more of your drives, and you go to Disk Management and expand the drive with no… Read more

0 comments, 79 reads

Posted in Technobabble by Klee from @kleegeek on 15 January 2018

Query Shortcuts in SSMS (Day 15)

There are several shortcuts that can be assigned to run a stored procedure. Known as Query Shortcuts, these can be assigned to the Alt+F1, Ctrl+F1 and the Ctrl+# keys.

For instance, highlight sys.databases below and press Alt+F1. sp_help will run against sys.databases, and it will produce the following output:

This… Read more

0 comments, 74 reads

Posted in A Discussion of SQL Server-Related Topics on 15 January 2018

Dissecting SQL Server, The Internal Structure of a Row

I’m sure that most of us know that SQL Server stores all it’s data in 8Kb pages.  But what do these pages actually look like and how can we go about looking at them and picking them apart.

For this we’re going to need a couple of undocumented DBCC commands,… Read more

1 comments, 88 reads

Posted in SQL Undercover on 15 January 2018

Reading GDPR

In case you’re interested, the GDPR law is actually not bad to read. You might be affected by this, so go through the regulations. I’m doing that this week.

You can also see a nice article from David Poole at SQLServerCentral.

I do think GDPR will affect many of us,… Read more

0 comments, 125 reads

Posted in The Voice of the DBA on 15 January 2018

Getting Started in a SQL Server 2017 VM in Azure

You say you’re ready to dip your toes in the Azure ocean? Come on in, the water’s fine!

Oh, you want to really dip your toes. You’re starting with Virtual Machines? OK. I guess. It’s not where the real excitement is. You should be checking out Azure SQL Database and… Read more

1 comments, 104 reads

Posted in The Scary DBA on 15 January 2018

Who should own the database?

TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and use that.

The database has to be owned by someone, doesn’t it? (FYI, yes it does) So who? How about Bob in accounting. It’s the accounting database. That makes sense… Read more

0 comments, 92 reads

Posted in SQLStudies on 15 January 2018

How I designed my VMware vSAN based Home Lab

(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.)

As you might know, I have already a quite powerful mobile Home Data Center that I have… Read more

0 comments, 211 reads

Posted in Klaus Aschenbrenner on 15 January 2018

Renaming a local windows login after SQL Server Computer Name Change

I had an interesting issue last week. I had to rename non-domain (Workgroup) SQL Server Virtual Machine in Azure. The server was running the Database Engine, Reporting Services and Integration Services

I actually run through a blog post I wrote the best of 8 years ago titled Renaming a Standalone Instance…

Read more

0 comments, 60 reads

Posted in The SQL DBA in the UK on 15 January 2018

SQL Saturday Nashville 2018

I decided to go to the SQL Saturday at Nashville this year to get some good learning and networking in during frigid January. One of the reasons I wanted to go was that the line up for precons was amazing and I wanted to learn more on Azure particularly. I… Read more

0 comments, 98 reads

Posted in Mala's Data Blog on 15 January 2018

Steps to Configure SQL Server to Listen On A Specific TCP Port

Management of the database is very much essential in today’s date and for doing this, there is a need to have a platform. SQL Server is one such platform to manage the database in a relational manner. It was developed by Microsoft and operated by many users, especially in different… Read more

0 comments, 179 reads

Posted in SQL Server Overview on 15 January 2018

Time to find a new place to live

Over the last couple of weeks I’ve been looking at various different locations around Dublin as my tenancy in the current flat that I’m in has run out.

There’s a bit of a housing problem in Dublin at the moment so it really hasn’t been easy but I’ve managed to… Read more

2 comments, 100 reads

Posted in The DBA Who Came In From The Cold on 15 January 2018

Linguistics Crisis In Microsoft Technology

With technology expanding in both complexity and quantity, the task to name each component and functions of a technology product becomes more daunting and thus creates the room for confusion and dubious meaning regarding terms used to explain the technology itself.

As a long time SQL Server DBA, I start… Read more

0 comments, 126 reads

Posted in DBA Philosophy on 15 January 2018

Object Explorer Drag-N-Drop (Day 14)

Did you know that items in the Object Explorer can be dragged and dropped into a query window? This can be a real time saver!

Drag the database name to have it put into the query window. Grab the table name and drag it to the FROM clause. Drag the… Read more

0 comments, 56 reads

Posted in A Discussion of SQL Server-Related Topics on 14 January 2018

The SSMS Super Clipboard (Day 13)

We’re all used to using the clipboard in Windows programs. You copy something into it with Ctrl+C, and paste it into your document with Ctrl+V. However, did you know that the SSMS clipboard remembers the last 20 items that were put into the clipboard, and that you can cycle through… Read more

0 comments, 152 reads

Posted in A Discussion of SQL Server-Related Topics on 13 January 2018

tsqlt Tests for Advent of Code 2017 Day 2

This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start with Day 1. As I worked through the puzzles, I decided that I should be testing using their test sets and solving the issues that way. This lets me use… Read more

0 comments, 205 reads

Posted in The Voice of the DBA on 13 January 2018

When it’s cold outside, perhaps Power BI heat maps can warm you up

(2018-Jan-13) You never know how the weather will behave itself, especially when the temperature gets dramatically changed from +10 to -10 within a day. During this Christmass and New Year holidays, it was very cold here in Canada. So I thought to explore some open data set that may contain…

Read more

0 comments, 118 reads

Posted in Data Adventures on 13 January 2018

Happy New Year… Late:)

Yeah I know its new year and i am back from quite some time. during these days i was learning things but could not able to make time to blog about it. This year would like to write more on … Continue reading

Read more

0 comments, 170 reads

Posted in Vinay Thakur on 13 January 2018

Alwayson Availability Groups vs Alwayson Failover Cluster Instances

SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It facilitates the function of data storing and retrieving by the applications which either run on the same or different platforms. The dominant reason behind the deployment of SQL Server on… Read more

0 comments, 913 reads

Posted in SQL Server Overview on 13 January 2018

Older posts