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

Archives: January 2017

SQL and the other technologies

Next table shows how SQL stands with the other technologies. The data is taken from StackOverflow.
Data charted looks like in the next figure

Read more

0 comments, 368 reads

Posted in SQL Mighty on 28 January 2017


I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired.

This post shows why you should use SCOPE_IDENTITY() instead of @@IDENTITY when using it with tables that have triggers.


Read more

0 comments, 154 reads

Posted in Si vis pacem, para sql on 27 January 2017

CloudProPT – The New Cloud/Azure Community in Portugal

I am so happy to share the news that as of today, the new community CloudProPT (as in Cloud for Portugal) is born. This new community will focus on the Cloud and on Microsoft Azure in particular.

This new community is being lead by André Vala with the likes of… Read more

0 comments, 368 reads

Posted in Niko's blog on 27 January 2017

Finding Sysadmins with dba tools–GetDbaRoleMember

I’ve been wandering through the dbatools set of cmdlets, trying to see where various cmdlets are useful, and also practicing some PoSh skills.

Recently I noticed there was a Get-DbaRoleMember cmdlet to use. Of course, when I tried to check it, I found an issue. I didn’t have the cmdlet… Read more

2 comments, 439 reads

Posted in The Voice of the DBA on 27 January 2017

Upcoming PASS Free Training

Here is a list of the upcoming PASS Virtual Groups and SQLSautrday Events.

January, 2017


Introduction to Oracle SQL and PL SQL

More Details

February, 2017


Linux OS Fundamentals for the SQL Admin

Read more

3 comments, 606 reads

Posted in The Smiling DBA on 27 January 2017


I've seen a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes be not the desired.
This post shows why you should use SCOPE_IDENTITY() instead of @@IDENTITY when using it with tables that have triggers.  

Read more

0 comments, 3,007 reads

Posted in SQL Mighty on 27 January 2017

Friday Reading 2017-01-26

Is it really still January? It seems like this month is dragging on a bit. Anyway, this week I’ve been reading…

Nearly everything has changed for SQL Server Powershell
The Scripting Guys at Technet go over the changes to SQL Server Powershell.

Learning Redis the hard way
Interesting post about… Read more

0 comments, 334 reads

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

Microsoft SQL Server 2016 Cumulative update 1 (CU1)

Microsoft just announced Microsoft SQL Server 2016 Cumulative update 1 (CU1)

Microsoft reference: [Click Here]

Ganapathi varma Chekuri

Read more

0 comments, 252 reads

Posted in Ganapathi's MSSQLLover on 27 January 2017

What’s a Database Encryption Key (DEK) in TDE

The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran across a few people struggling to understand, so I decided to cover the concepts in a series of posts. This one looks at the Database Encryption Key (DEK).

The Purpose…

Read more

1 comments, 1,584 reads

Posted in The Voice of the DBA on 26 January 2017

Backup/Restore–What’s My Status?

The day begins and you find yourself going through a list in your mind of things that need to be accomplished. You either make a mental note, jot it down on paper, or input notes into your mobile device. The day is getting off to a great start; you feel… Read more

1 comments, 1,804 reads

Posted in The SQL Professor on 26 January 2017

SQL Server Community Events

By David Postlethwaite

I have just come back from a successful SQL Saturday in Vienna, Austria where I had 60 people listening to my presentation on SQL 2016 new features.
It was interesting how many people still wanted to know about SQL Server 2016 even though it’s been out for…

Read more

0 comments, 489 reads

Posted in The SQL DBA in the UK on 26 January 2017

Querying My Named Instance in PoSh–#SQLNewBlogger

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

I was looking at some sample code the other day and it looked like this.

cd sqlserver:\sql\localhost\default\databases

This allows you to browse the list of databases on… Read more

0 comments, 556 reads

Posted in The Voice of the DBA on 25 January 2017

Setting Up a Productive Work Environment – #TAPtips

Having a productive work environment for you and your team is important to facilitate tasks being accomplished as well as having fun at the office. We spend so much time working that even the littlest of things can make the world of difference. Being a consultant, I’ve worked in a… Read more

2 comments, 1,754 reads

Posted in Marc Beacom on 25 January 2017


Let’s talk about the DATEDIFF vs. DATEADD functions in SQL Server. Each one performs a different task. The former calculates the differences between two given date & time values based on some date part (day, minute, second, etc.). The latter calculates a date & time value by adding a number… Read more

0 comments, 1,479 reads

Posted in Guy Glantser on 25 January 2017

Career Corner: Go Beyond Networking

Networking with others is good for your career. You should do it. Don’t stop there. Keep going.

Networking builds contacts and associates you can reach out to with respect to your technical discipline. You need these to grow effectively in your career.

However, networking typically stops at the technical side.… Read more

0 comments, 441 reads

Posted in Databases – Infrastructure – Security on 25 January 2017

Compare column names for case sensitivity

I’m reviewing the code for the upcoming Minion CheckDB, and one of the things we’re checking for is case consistency in column names. For example, if Table1 has a column named Col1, and Table2 has COL1, well that’s no good. But, how do we easily find those mismatches on a… Read more

3 comments, 673 reads

Posted in SQL Awesomesauce on 25 January 2017

My SQL logins don’t work. Again.

My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one was on how to create a connect item and then this one. It was pointed out to me that the errors in the log have quite a bit more information… Read more

0 comments, 2,321 reads

Posted in SQLStudies on 25 January 2017

Running SSMS 2016 in Read Uncommitted Mode

Back in July when we received the first official release of SSMS not tied to an engine release we got a new SQL PowerShell module and we also received the ability to run SSMS in Read Uncommitted mode via a registry setting.

I was hopeful that this new option would… Read more

3 comments, 1,839 reads

Posted in SQLvariant on 25 January 2017

Transaction log shipping in SQL Server on Linux

SQL Server on Linux has been out for a bit now and I’ve played around a little (see here) but haven’t really used it in “anger” nor will I for the foreseeable future if I’m honest. Nevertheless it’s an area that I find very interesting as I know very… Read more

5 comments, 1,832 reads

Posted in The DBA Who Came In From The Cold on 25 January 2017

Interactive query experience for SQL databases

This is a new feature where you can issue TSQL commands via a TSQL editor straight from the Azure portal, why this is great is because sometimes you do not want to keep switching between your SSMS (SQL Server Management … Continue reading

Read more

1 comments, 547 reads

Posted in All About SQL on 25 January 2017

Newer posts

Older posts