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...
2017-01-27
515 reads
Blog Posts
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...
2017-01-27
393 reads
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
2017-01-27
311 reads
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”...
2017-01-27 (first published: 2017-01-20)
1,507 reads
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...
2017-01-27
276 reads
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...
2017-01-27
5 reads
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...
2017-01-27
4 reads
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...
2017-01-27
665 reads
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...
2017-01-26 (first published: 2017-01-19)
1,438 reads
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...
2017-01-26
578 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers