A Fine Slice Of SQL Server
Rob Farley has a quick script to find references in SQL Server:
As a consultant, the kind of work that I do from customer to customer can change a bit. Sometimes I’m reviewing people’s environments; sometimes I’m performance tuning; sometimes I’m developing code or reports or cubes; sometimes I’m writing T-SQL, but it’s often DAX or PowerShell.
Click through for a quick script to search modules for a particular string.
Comments closedJohn McCormack lays out the parameters for this T-SQL Tuesday:
T-SQL Tuesday this month is going back to basics and its all about code. I’d like to know “What are your go to handy short scripts”?
What are those little short bits of code that you can’t live without? I’m talking about little snippets that are only a few lines, that you may even have memorised. It could be T-SQL, PowerShell, Python or anything else you use day to day.
Click through for two of John’s.
Comments closedAnthony Nocentino has a round-up for us:
I want to start by saying thank you to all who submitted, and an amazing collection of people submitted some fantastic content. Also, thanks to Steve for asking me to host and being patient with me for mixing up the dates and the hashtag. It’s #tsql2sday and it’s on Tuesday not Wednesday 😛
Click through for links to the entrants.
Comments closedKevin Chant shows off a good use case for containers:
Anyway, during these sessions we tend to do a pipeline demo like the one below. Done within either Azure Pipelines in Azure DevOps or GitHub Actions. I use a standard set of containers locally for both demos. In order to show how to do show deployments to local SQL Server 2019 instances and databases in Azure within one pipeline.
Read on for more.
Comments closedMark Wilkinson combines Telegraf, InfluxDB, and Grafana:
Lots of folks wonder why I would go through the trouble of building out a system when so many vendors have already solved the problem of collecting baseline metrics. The answer at the time was simple: cost. With my setup I could monitor close to 600 instances (including dev) for $3,000 USD per year. That includes data retention of ~2 years! Are there some administration costs as far as my time is concerned? Of course. In the begining things were a little rough as I learned more about InfluxDB, but once things were configured correctly the most work I’ve had to do is to expand the size of the data drive as we started collecting more metrics.
Click through for more info and check out the GitHub repo.
Comments closedAndy Leonard closes shop on another successful T-SQL Tuesday:
This month’s T-SQL Tuesday attracted some great responses! Thank you to everyone who participated!
Click through for links to all of the respondents and for Andy’s excellent summaries and thoughts.
Comments closedSteve Jones wraps up the latest T-SQL Tuesday:
I hosted the blog party this month, with the invite to write about notebooks. These are a neat technology, and I’ve written about them at SQLServerCentral.
This post is a wrap-up of the various responses to my invitation. First, quite a few people give credit to either Aaron Nelson or Rob Sewell for their writings and work with notebooks, so check out their blogs.
Click through for the list of respondents.
Comments closedI have to admit that I do not use Jupyter notebooks or Azure Data Studio (ADS) everyday. Last August, I made separate Jupyter notebook versions of my SQL Server Diagnostic Information Queries. There was a separate version for SQL Server 2012 through SQL Server 2019, along with one for Azure SQL Database. This was after a number of requests from people in the community.
Creating these notebooks was a pretty decent amount of work. Luckily, this was right around the time that Azure Data Studio was making it much easier to edit and format markdown for the text blocks. Since then, Azure Data Studio is even easier to use for editing and formatting. Even more fortuitous was the fact that Julie Koesmarno (@MsSQLGirl) volunteered to greatly improve my formatting!
Unfortunately, there has not been as much interest in my Jupyter notebooks as I hoped for. There are probably a number of reasons for this.
Read on for Glenn’s notes.
Comments closedRob Farley has a change of heart:
The concept is that if I have a notebook with a bunch of queries in it, I can easily call that using Invoke-SqlNotebook, and get the results of the queries to be stored in an easily-viewable file. But I can also just call Invoke-SqlCmd and get the results stored. Or I can create an RDL to create something that will email me based on a subscription. And I wasn’t sure I needed another method for running something.
Read on to see what changed Rob’s mind.
Comments closedBrent Ozar rounds up the usual suspects, plus several more:
For this month’s T-SQL Tuesday, I asked you to blog about your most-loved and least-loved data types.
Crazy, right? How could people possibly love or hate data types? Well, if you’ve been working with them for a while, I figured you’d have built up an array of tips or pain points, and y’all delivered with 29 interesting blog posts.
Click through for a lengthy list of interesting posts.
Comments closed