-->
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
References:

Read more

0 comments, 274 reads

Posted in SQL Mighty on 28 January 2017

SCOPE_IDENTITY() or @@IDENTITY

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.

CREATE DATABASE IdentDB;
GO…

Read more

0 comments, 74 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, 274 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, 326 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

Tuesday,January,31

Introduction to Oracle SQL and PL SQL

More Details

February, 2017

Wednesday,February,01

Linux OS Fundamentals for the SQL Admin

Read more

3 comments, 510 reads

Posted in The Smiling DBA on 27 January 2017

SCOPE_IDENTITY() or @@IDENTITY

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.  
CREATE DATABASE IdentDB;

Read more

0 comments, 2,861 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, 252 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
Lead SQL DBA, MCP

Read more

0 comments, 162 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,424 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,713 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, 377 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, 420 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,670 reads

Posted in Marc Beacom on 25 January 2017

DATEDIFF vs. DATEADD

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,133 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, 379 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, 573 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,192 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,650 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,555 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, 490 reads

Posted in All About SQL on 25 January 2017

Newer posts

Older posts