Should DBAs learn Linux?
Brent Ozar looks at the similarities between SQL Server on Linux and SQL Server on Windows Core from back in 2012, and asks whether DBAs should bother learning it.
2017-10-02
4,169 reads
Articles
SQL Prompt Tip: how to control when the suggestion box pops up
By default, SQL Prompt shows code auto-completion suggestions automatically, and continuously. 90% of the time this is exactly what you want, but there are other times where you just need a bit of space - Phil Factor shows how.
2017-10-02
2,880 reads
Implementing SQL Server Failover Clustering in Azure
Deploying IaaS solutions in Microsoft Azure offers benefits that leverage agility, resiliency, and scalability built into the underlying platform. However, when dealing with business-critical workloads, customers typically want to also provide high-availability and disaster recovery capabilities in a manner that they can control. Trying to implement this approach in the cloud by following the procedures applicable in on-premises datacenters frequently presents challenges. This article focuses on these differences in the context of deployment of SQL Server Failover Clustering in Azure.
2017-09-29
3,141 reads
Guide to Create a SQL Central Management Server
This post is going to walk you through the process of creating an SQL Management Server.
2017-09-28
8,992 reads
Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML
How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL Server table that represents a simple hierarchy within an organisation. Well once you know, it is easy and William Brewer is on a mission to tell you how.
2017-09-28
6,087 reads
How to use a Project in SQL Server Management Studio
Matteo Lorini shows how to setup a project in SSMS to organize files.
2017-09-27
4,539 reads
Azure DWH part 16: BCP to import and export data
In Azure SQL Data Warehouse we can use BCP to export or import the data. In this article, we will show how to do it.
2017-09-26
2,192 reads
What If Week: What Would You Fix Or Change?
Brent Ozar, Erik Darling, and Tara Kizer think about what they would change or fix if they had access to SQL Server’s source code.
2017-09-26
3,774 reads
When sp_HelpText is not so helpful!
A note of caution on the use of sp_helptext to script out objects.
2017-09-25
2,772 reads
SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server
SQLCLR is now considered a robust solution to the few niche requirements that can't be met by the built-in features of SQL Server. Amongst the legitimate reasons for avoiding SQLCLR, there is the fear of getting bogged down in code with special requirements that is difficult to debug. Darko takes a real example, extending the features of sp_send_dbmail, to demonstrate that there need be few terrors in SQLCLR.
2017-09-25
7,840 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers