SQL Relay 2016
It less than week to SQL Relay - a week long SQL conference that is visiting Birmingham, Cardiff, Reading, Nottingham and...
2016-09-27
504 reads
Blog Posts
SQL Server: Monitoring Disk Space with FSUTIL command line utility
Table of Contents
IntroductionPre-requisitesData flowEnable xp_cmdshellDownloadSQL CodeOutputConclusionReferencesSee Also
Introduction
This article talks about one of SQL method to fetch the disk usage details...
2016-09-27
1,651 reads
TSQLCircleLive: What will be the result of the query below? Explai...
TSQLCircleLive: What will be the result of the query below? Explai...: select case when null = null then 'True' else 'False'...
2016-09-27
346 reads
A Goal of Speaking at PASS Summit
Everyone has goals or at least they should have goals. As a young professional out of college, I had plenty...
2016-09-26
569 reads
Different types of ANSI standard joins
INNER JOIN (SIMPLE JOIN): This returns all rows for which there is at least one match in BOTH tables. This is...
2016-09-26
277 reads
Future DBA – Hadoop Big Data 1
In our last blog on Hadoop Big Data we have discussed about Hadoop and its tools/utility to connect to HDFS. on...
2016-09-26
594 reads
Nil to Speaker: Improving your PowerPoint skills
As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve...
2016-09-26
602 reads
Setting DBCC 1222 on startup
The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)
However, once the SQL instance is restarted this...
2016-09-26 (first published: 2016-09-19)
1,745 reads
Using an ORDER BY in a view
For many years it’s been a best practice to never put an ORDER BY in a view. The idea is...
2016-09-26 (first published: 2016-09-19)
3,684 reads
What does UNION do or what result set UNION return ? What is the difference between UNION and UNION ALL?
UNION merges the contents of two structurally-compatible tables into a single combined table. This return unique records from all the...
2016-09-26
181 reads
Blogs
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
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...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers