Step By Step configring Windows 2012 R2 fail over cluster
One of my client requirement is to install Always on availability groups for SQL databases. You don't require shared storage...
2017-03-01
3,002 reads
Blog Posts
Step By Step configring Windows 2012 R2 fail over cluster
One of my client requirement is to install Always on availability groups for SQL databases. You don't require shared storage to setup Always on availability. it can be configured...
2017-03-01
11 reads
Upgrading SQL Server on Linux
I saw this week that there was a new CTP (v1.3) of SQL Server v.Next. I haven’t had a lot...
2017-03-01 (first published: 2017-02-23)
4,815 reads
Better SQL Agent Job Alerts
They kinda suck. I mean it is nice that we have the option for the SQL Agent to tell us...
2017-02-28 (first published: 2017-02-23)
3,483 reads
Error while loading Excel data into database
Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a...
2017-02-28 (first published: 2017-02-21)
4,869 reads
How Do I Add an R Package to SQL Server from In-Database R?
Hello Dear Reader! I'm working on some really fun stuff with in-database R using SQL Server 2016. I needed to add a couple packages to my R engine so...
2017-02-28
6 reads
How Do I Add an R Package to SQL Server from In-Database R?
Hello Dear Reader! I'm working on some really fun stuff with in-database R using SQL Server 2016.
I needed to...
2017-02-28
911 reads
Azure Cognitive Services Text Analytics – An API Calling Application
[read this post on Mr. Fox SQL blog]
Just last week we had the fantastic opportunity to present at Microsoft Ignite 2017 in...
2017-02-27 (first published: 2017-02-22)
2,876 reads
Database cloning – CLONEDATABASE
Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1 support cloning. The command syntax is very simple [crayon-5e81b52ed8fb5359335187/]...
2017-02-27
22 reads
Database cloning – CLONEDATABASE
Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1...
2017-02-27
707 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers