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

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

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 ChekuriLead SQL DBA, MCPLinkedin

Retrieve a List of Files from FTP using SSIS

The FTP protocol is one of the oldest methods for sharing and moving files. Although frequently considered to be an “old-school”...

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

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

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

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 Server 2016 Bug in R Integration?

 
I am studying the latest R integration with SQL Server 2016, and I believe I encounter a bug when using...

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