Speaking at SQLBits next month
As I mentioned a couple of weeks ago, I will be presenting for the first time at SQLBits in London,...
2018-01-24
340 reads
Creating a SQL Server Test Lab On Your Workstation – Part Three, Creating a Windows Failover Cluster and a SQL Server Availability Group
Welcome along to the third part of our series ‘Creating a SQL Server Test Lab On Your Workstation’. If you’ve...
2018-02-02 (first published: 2018-01-24)
2,230 reads
SQL Server User Already Exists – Back to Basics
One of my all-time favorite things in SQL Server is security. No matter what, it always seems that there is a new way to abuse permissions. When people abuse...
2018-01-24
36 reads
SQL Server User Already Exists – Back to Basics
One of my all-time favorite things in SQL Server is security. No matter what, it always seems that there is...
2018-01-24
537 reads
Help it takes forever to open the SQL Server Log!
Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the...
2018-01-24
453 reads
Maintaining Balance
Last week, I got the chance to give my I’m It Survival Tips for the Lone DBA in a webcast for the first...
2018-02-09 (first published: 2018-01-24)
1,659 reads
Know How to Recover SQL Server Database Without Backup
Microsoft SQL Server has widely used database management system for storing and retrieving data. It stores its files in MDF,...
2018-01-24
605 reads
Configuring Persistent Storage for SQL Server in Azure Container Services
I’ve been playing around with SQL Server running in Kubernetes in Azure Container Services (AKS) for a while now and...
2018-02-01 (first published: 2018-01-24)
1,499 reads
Power BI Custom Visuals Class (Module 87 – Funnel with Source MAQ Software)
In this module you will learn how to use the Funnel with Source Custom Visual by MAQ Software. The Funnel...
2018-01-30 (first published: 2018-01-24)
1,264 reads
Will GDPR cause a “Database Run”?
What is GDPR, everyone’s (current) favorite acronym? It stands for “General Data Protection Regulation” and is an act / law / set...
2018-02-05 (first published: 2018-01-23)
2,415 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers