Daily Coping 29 Sep 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-29
8 reads
Blog Posts
Join SQLSat Memphis Virtually This Saturday
Looking forward to presenting at SQLSaturday Memphis virtually this weekend!
Both my wife and I are on the schedule for Saturday, and the organizers chose interesting nontechnical topics for both...
2020-09-29
6 reads
Power BI Monthly Digest – September 2020
In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.
2020-09-29 (first published: 2020-09-22)
318 reads
sp_RestoreScript 1.7 Released
sp_RestoreScript 1.7 has been released. For information and documentation please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ Changes in 1.7 New Parameters @IncludeCopyOnly – 1 – Copy only backups are included0 – Copy only...
2020-09-29
181 reads
[MSSQLTips] Visual Studio 2019 Configuration for the Production DBA
Happy Tuesday everyone… Today I am honored to have my first article published on MSSQLTips.com. As a Production SQL Server Database Administrator, you do not usually find yourself in...
2020-09-28 (first published: 2020-09-22)
587 reads
Converting a Datetime to UTC
I was in a need of converting some datetime values (of which I know the actual timezone) to UTC dates. A quick Google search showed me that most results...
2020-09-28 (first published: 2020-09-22)
1,147 reads
Daily Coping 28 Sep 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-28
35 reads
Azure SQL Offers Manual Failover for PaaS Resources
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a...
2020-09-25 (first published: 2020-09-22)
230 reads
Daily Coping 25 Sep 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-25
38 reads
Git Tricks–Getting a New Remote Branch–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is probably more for me than anyone,...
2020-09-25 (first published: 2020-09-16)
184 reads
Blogs
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Data Conferences – Worth Every Dollar
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
Forums
A Place where AI Technology Shines
Comments posted to this topic are about the item A Place where AI Technology...
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers