Export AdventureWorksDW2017 to Excel for a Power BI Demo with Export-Excel
Have you ever wanted to export an entire SQL Server database to Excel file? Yeah, me neither. Until yesterday, when...
2019-03-28 (first published: 2019-03-14)
571 reads
Blogs
Querying temp tables across a linked server.
And if you are still reading you probably fit into one of the following categories.
Not a DBAA relatively new DBALike...
2019-03-27 (first published: 2019-03-14)
618 reads
SQL Server – max server memory
Another re-post of a video from last year, this time showing you an in-built protection of setting max server memory...
2019-03-14
471 reads
#ITechDay in Warsaw
We were enjoying Thursday on conference in Warsaw. We have arrived pretty lately but easily saw the awesome atmosphere there....
2019-03-13
249 reads
Achieving SQL Server HA/DR with a mix of Always On Availability Groups and SANless SQL Server Failover Cluster Instances
Introduction
The topic of mixing SQL Server Failover Cluster Instances (FCI) with Always On Availability Groups (AG) is pretty well documented....
2019-03-13
1,814 reads
Does SQL Server 2019 run on Ubuntu 18.04 LTS?
Yes. Here’s the proof from an output of SELECT @@VERSION: [crayon-5c98bf6b3202b962253620/] Here’s a screenshot of me running mssql-cli on the...
2019-03-13
671 reads
Database Development Gone Wrong
I recently shared a story about how I was personally responsible for a development project going off the rails (and...
2019-03-13
428 reads
Telegraf Setup FAQ for Troubleshooting
I often get emails asking the same time of questions about the setup of Telegraf for SQL Server and Windows...
2019-03-13
426 reads
Enable Mail Profile – Back to Basics
I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to...
2019-03-13
259 reads
Quick tip: Zoom in Azure Data Studio
If you finally have given a try to Azure Data Studio, and if you use it on a regular basis,...
2019-03-13
2,055 reads
Blogs
New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
Join Denny Cherry and Associates at SQL Bits 2023
I am very excited and lucky to be speaking once again at SQLBits along...
Daily Coping 27 Jan 2023
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Forums
Case statement with time
Hello everyone I hope everyone's ok. I have this query and I'm trying to...
what are the best books to become a SQL developer?
what are the best books to become a SQL developer?
what are the best books to become a DBA SQL?
what are the best books to become a DBA SQL?
Ask SSC