Podcast: Myths of Modern Data Management
As part of the Secrets of Data Analytics Leaders by the Eckerson Group, I did a 30-minute podcast with Wayne Eckerson where I...
2018-04-02
175 reads
Blog Posts
Power BI Data Security – Sharing in Email
Microsoft has expanded sharing by allowing users to share Power BI content via email. In a previous post, I discussed...
2018-04-02 (first published: 2018-03-22)
2,133 reads
Primary Replica Jobs
This post talks about having primary replica jobs. That is, jobs that will only run on the primary replica of...
2018-04-02
975 reads
SQL Homework – April 2018 – Indexes
This month we are going to look at a topic near and dear to both database developers and database administrators...
2018-04-02
320 reads
Database Superhero Adventures, April 2018 Edition
Chicago O’Hare AirportI had two SQL Saturdays this month SQLSaturday Chicago and SQLSaturday Rochester both of which were very cold....
2018-04-01
272 reads
SQL Server Extended Availability Groups
It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may be no surprise to many that Microsoft has also...
2018-04-01
12 reads
SQL Server Extended Availability Groups
It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may...
2018-04-01
410 reads
Authentication issues with GitHub: An error occurred while sending the request —> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel.
This blog post is about an error that you may receive if you’re using git commands in PowerShell and authenticating...
2018-03-31
708 reads
Azure SQL Database Manage Instance
Azure SQL Database Managed Instance is bridging the gap between 0n-premises SQL Server and Azure SQL Database. Azure SQL Database...
2018-03-31
738 reads
Geometry Objects in SQL Server using Latitude/Longitude coordinates
(2018-Mat-31) Support for spatial geometry functions was initially introduced in SQL Server 2008 and then it was greatly improved in...
2018-03-31
3,731 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers