SQLSaturday #913 Minnesota
It's been a couple of years since I have been able to attend a SQL Saturday. I was grateful I was able to make it this year. This year however was a first for me, it was my first SQL Saturday in Minnesota and the first time I went to a precon, both were enjoyable. On...
AlwaysOn Failover Cluster Instance
Recently, I was working with a gentleman in our IT department and we were discussing adding redundancy to a couple of SQL Servers that were used for web apps. Turns out, VMware's disk consolidation can, and will, take a server offline. That tends to make customers...
SQL Backup command – STATS keyword
I'm not sure why I hadn't noticed this before, or why it suddenly seemed like such a novel concept to me, but while I was running a backup command one on SQL I realized what the STATS keyword actually does (red circle below). Then it hit me, it's the interval that...
I’ve been busy…
I doubt anyone has noticed, or really frequents this blog for much. Maybe a few people swing through to grab saved links, and that's okay. This blog is mainly for me anyway as a place to take notes and save resources so I can find them fast. So maybe this post is just...
Year end review and thankful
It's Thanksgiving Day and before we know it, Christmas and New Years will be upon us. 2018 hasn't worked out as I planned last year. In fact, 2018 has been a difficult year for me personally. The first half of the year Jan - April was rough for a number of reasons. It...
Well Bye……Google
I've been in IT a long time, coming up on 20 years. When I begin Yahoo was a titan, Excite was still around, and I felt snobbish with Ask Jeeves (they had a butler as a logo....hence the snobbish feel...) but the search engine that I ended up gravitating to was...
DBA/Developer learning resources for Microsoft SQL Server
One of the hardest things to do when looking to start out in the SQL world, is to find quality sources to learn from, or just not get overwhelemed with information. To help alveiate that, I have assembled a list of resources that I use to continue learning and...
Office Conditions
I have worked in an office environment for a long time. Going on twenty years in fact. I have worked in a number of different types of environments, but cubicles have been the standard. In fact, in my career I have only had a walled office a couple of times - shared...
K. Fisher’s Homework – Create db
In December the topic of the month for #Tsql2sday was to talk about our learning goals for 2018. One of the goals I put forth was to get better at SQL development. As part of that goal, I also realized I have to get more familiar with Visual Studios. So to help with...
Postgresql follow up
A couple of weeks ago I was given the task of helping a developer figure out why his Postgresql cluster wouldn't fail over. The specific problem was to test failover prior to launching the Postgresql cluster in to Production. Sounds easy enough,, right? Setting things...
Micrsofot SQL Server Blog
- Mssql extension for Visual Studio Code now has Object Explorer and IntelliCode
- The October 2019 release of Azure Data Studio is now available
- SQL Server Management Studio 18.3 is now generally available
- The September release of Azure Data Studio is now available
- Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters