Playing with TDE
UPDATE November 2016 – With SQL Server 2016 SP1, Microsoft will include key enterprise-class features in every edition of SQL Server...
2016-07-27
525 reads
Arun Sirpal
SQLskills Training
Well I finally accomplished a goal of mine– that being to complete the training for SQL Server Performance Tuning and...
2016-07-12
192 reads
Azure SQL Database scripts
I thought that this would be useful for others – couple of scripts that I have been using in Azure for...
2016-07-01
187 reads
Configuring geo-replication for an Azure SQL Database
This article will discuss geo-replication for an Azure SQL Database (PaaS) and the steps required for setup via the Azure portal and TSQL.
2016-06-27
1,939 reads
sys.dm_db_wait_stats DMV
Come on guys, lets “UP- vote” this suggestion for the actual SQL Server product – even the “Scary DBA” likes the...
2016-06-02
247 reads
PowerShell – Deleting those files
Usually I prefer to use C# to delete files (as part of my retention policy for backups) as a stored...
2016-06-01
172 reads
Wait Types and Latch Classes Library
Great news from SQLSkills.”Announcing the comprehensive SQL Server Wait Types and Latch Classes Library” – Paul S. Randal http://www.sqlskills.com/blogs/paul/announcing-the-comprehensive-sql-server-wait-types-and-latch-classes-library/ It has...
2016-05-10
275 reads
SQL Server Resource Governor
Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.
2016-04-26
3,693 reads
Migrating an on premise SQL Server Database to Azure
For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.
2016-04-21
1,726 reads
Symbols
I just want to write the setup I went through for using debug symbols within SQL Server to resolve call...
2016-04-20
227 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers