Weekly reading #1
Damian. My name is Damian. Maybe you already know me from the previous blog which I had to leave. I...
2019-02-04
50 reads
Tidier PowerShell Scripts with Default Parameter Values
I was recently working on a PowerShell script to set up some new databases for my users and found myself writing the same things over and over again.
1 2...
2019-02-04
27 reads
#Python101 with Dominika
Take a look into first article about Python prepared by Dominika. You can find it here.
2019-02-03
65 reads
Last Week Reading (2019-02-03)
Press Webinar Follow-Up: Top 4 Data Technology Trends for DBAs in 2019 Very interesting discussion panel led by Kevin Kline...
2019-02-03
174 reads
SQLServerCentral SSAS Tabular Series: 5th Article Cleaning Up Dimensions
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the beginning article before reading this one in order to...
2019-02-03
45 reads
SQLServerCentral SSAS Tabular Series: 5th Article Cleaning Up Dimensions
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the...
2019-02-03
185 reads
Generating Insert Statements
G’day,
I been asked a few times lately the best way to generate INSERT statements.
I’d always replied to use SSMS.
I know...
2019-02-25 (first published: 2019-02-02)
2,573 reads
SQL Server Monitoring: What queries should you monitor?
I previously wrote about measuring wait statistics. This matters a lot, because you can track historically what wait statistics are...
2019-02-02
377 reads
"A connection timeout has occurred on a previously established connection to availability replica"
I previously spent some time troubleshooting this issue at one client, and then having encountered it twice more this year, I figured I'd include it in a blog post....
2019-02-01
6,290 reads
Modern Hardware with 64 CPUs
In today’s world, more often then not you might run into systems that have large beefy hardware. Hundreds of gigabytes...
2019-02-21 (first published: 2019-02-01)
2,483 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers