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

Latest Blog Posts

SQL Server vs Oracle: Top N rows

In today’s continuation of the SQL / Oracle series, I thought it’d be nice to show how different the two are for retrieving the top number of rows.

SQL Server

There are a couple different ways to get the top rows in SQL Server. You can either do this by… Read more

0 comments, 30 reads

Posted in Confessions of a Microsoft Addict on 9 August 2017

Using PowerShell to check if your password has been in a breach

We know that we need to keep our credentials secure. We know that we should not re-use our passwords across different services. Hopefully, by now, most readers of this blog are aware of Troy Hunts excellent free service https://haveibeenpwned.com/ which will notify you if your email has been found in… Read more

11 comments, 1,130 reads

Posted in SQL DBA With A Beard on 9 August 2017

TSQL Tuesday #93: 2 Job Interviews

T-SQL Tuesday #93

I decided to join the T-SQL Tuesday blog series that Kendra Little is leading this month, on the topic that is called “Interviewing Patterns & Anti-Patterns

The Job I HAD to skip

Please, take this first part in the context of somebody, who was largely… Read more

2 comments, 206 reads

Posted in Niko's blog on 8 August 2017

I Hate Interviews – TSQL2sDay

This month’s T-SQL Tuesday is hosted by Kendra Little and is on the topic of interviews 

I hate interviews as an interviewee. I have had many memorable experiences with them. Even writing this blog post has been challenging as I relive some of them. I haven’t shared a lot of… Read more

4 comments, 183 reads

Posted in SQL DBA With A Beard on 8 August 2017

SQL Server on Linux Series: Backing up over the network

One of the challenges with any SQL Server business continuity strategy is backing up your databases and logs on a frequent basis. With Windows, we’ve known how to accomplish this for years. But, with SQL Server on Linux, you can accomplish the same task with just a few different… Read more

1 comments, 258 reads

Posted in Technobabble by Klee from @kleegeek on 8 August 2017

Power BI – Problem, Design, Solution (Text Search Slicer)

There is a video that walks you through the solution in depth, please find the video at the end of this post along with the completed solution.

In this installment of the Problem, Design, Solution series we are going to show you how to perform a text search using slicers… Read more

2 comments, 167 reads

Posted in Devin Knight on 8 August 2017

Transparent Data Encryption with Azure Key Vault

Microsoft introduced Transparent Data Encryption (TDE) to SQL Server with the 2008 release providing a simple, easy way to add an extra layer of protection to our data. TDE is not unique to SQL Server and hasn’t changed much since being introduced into the product. With Azure becoming more and… Read more

1 comments, 301 reads

Posted in Bradley Schacht on 8 August 2017

Microsoft Big Data Certification Exams

I previously blogged about Microsoft certification changes, and since then there have been some new Microsoft Big Data certifications exams released:

Already live:

70-773: Analyzing Big Data with Microsoft R Server

70-774: Perform Cloud Data Science with Azure Machine Learning

70-775: Perform Data Engineering on Microsoft Azure HDInsight

Now… Read more

1 comments, 125 reads

Posted in James Serra's Blog on 8 August 2017

How to be a bad interviewer

In the monthly SQL blogging party that is T-SQL Tuesday (brainchild of Adam Machanic), Kendra Little has invited us this month to talk about interview patterns/anti-patterns.

Before my current role which I’ve been in for just over 5 years, I spent most of my career as a contractor, performing… Read more

7 comments, 951 reads

Posted in Matthew McGiffen DBA on 8 August 2017

A Quick Start Guide to Managing SQL Server 2017 on CentOS/RHEL Using the SSH Protocol

This article details the following

  1. How to get PuTTY and SQL Server
  2. How to install/uninstall SQL 2017 CTP2.1
  3. How to Upgrade to SQL 2017 RC1
  4. How to Install/remove SQL Tools

In one of my previous articles Installation of SQL Server vNext CTP on Linux Distribution CentOS 7, I spoke… Read more

0 comments, 165 reads

Posted in PowerSQL By Prashanth Jayaram on 8 August 2017

Interviews and Oranges

What a great topic for this month’s T-SQL Tuesday hosted by Kendra Little https://littlekendra.com/2017/08/01/tsql-tuesday-93-interviewing-patterns-anti-patterns/

The topic being: Interviewing Patterns and Anti-Patterns. I have had MANY (50 +) interviews over time with a lot of failures, so what have I learnt?

  • Be honest! This starts from your CV. If you lied…

Read more

5 comments, 112 reads

Posted in All About SQL on 8 August 2017

#TSQL2sday: Interviewing Patterns

This T-SQL Tuesday is hosted by Kendra Little.

I’ve been told interviewing is an art. Perhaps it is. I view it more as an information exchange. The organization you’re interviewing with is trying to obtain information on you. You should be trying to obtain information on the organization. The… Read more

3 comments, 105 reads

Posted in Databases – Infrastructure – Security on 8 August 2017

SSIS – Error while deploying package The locale identifier (LCID) is not supported by SQL Server

A quick blog post about an issue I encountered today. I tried deploying a simple SSIS project to my local SSIS catalog. No biggie. However, at the last step of the deployment I was greeted with the following .NET error:

A .NET Framework error occurred during execution user-defined routine or…

Read more

0 comments, 129 reads

Posted in Koen Verbeeck on 8 August 2017

Interview Patterns and Anti-Patterns Combined

It’s that time again. T-SQL Tuesday. The monthly blog party started by Adam Machanic (b/t) seven and a half years ago!! We have a host, who picks a topic (on the first Tuesday of the month) and then we all write about that topic over the… Read more

4 comments, 96 reads

Posted in SQLStudies on 8 August 2017

T-SQL Tuesday #93–Interviewing Patterns

It’s time for T-SQL Tuesday, and this is a good topic. Not too close to T-SQL, but certainly something many people are interested in.

Kendra Little hosts this month, and her topic is interviewing patterns and anti-patterns. Things that are good, or things that might appear good, but are… Read more

0 comments, 188 reads

Posted in The Voice of the DBA on 8 August 2017

Learn How to Recover Deleted Records from SQL Server 2014


Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their records are deleted due to which they face a lot of issues. To maintain the workflow they need to recover deleted records from SQL Server 2014. This could be… Read more

0 comments, 152 reads

Posted in Vivek's SQL Notes on 8 August 2017

SQL Server vs Oracle: End of Month

Continuing my series on SQL Server and Oracle, I thought I’d highlight a function that has been in Oracle from some time and has only just recently appeared in SQL Server.

End of Month

Getting the end of the month is a really important task for any report writer or… Read more

1 comments, 22 reads

Posted in Confessions of a Microsoft Addict on 8 August 2017

Presentation Nerves

My previous post on interviews and a number of conversations this year inspired me to write this post. I am lucky enough to have been selected to speak at numerous events over the past few years and I am really lucky because I thoroughly enjoy doing them. The feedback I… Read more

3 comments, 175 reads

Posted in SQL DBA With A Beard on 8 August 2017

Capturing Perfmon Counters With Telegraf

InfluxDb & Grafana Series

I had a lot of issues with getting the GO enviroment setup in windows, this time and previous times. For using… Read more

0 comments, 107 reads

Posted in SQL Barbarian on 8 August 2017

Data modeling in Power BI using XML file with Parent and Children nodes

[2017-Aug-08] Support for XML structured files as a data source has been available in Excel, then was introduced into the Power Query data extract engine of the same office application which later migrated into the Power BI data modeling tool.

My recent experience working with XML data files at the…

Read more

0 comments, 261 reads

Posted in Data Adventures on 8 August 2017

Newer posts

Older posts