Are you a DBA and just inherited a SQL Server or Oracle database? Are you migrating from one or the other? I’ve decided to start a series comparing these two RDBMS giants and the first topic is date formatting.
Category: Administration
Need to output CSV, TSV, or other?
Ever have the need to create a CSV list in SQL Server? Not sure how? Starting in SQL Server 2017 we get a new native function to do exactly that. Specify a delimiter and you get a delimited list.
How to display more text in SSMS
Today’s blog post is going to be a short one but can be very helpful if you’re new to SQL Server. From time to time you may find the need to use the text result instead of the default grid result. You can change this by using CTRL-T for text and CTRL-D for grid. Read More »
Reading the log on SQL for Linux
The SQL Server errorlog is a really helpful place to find all sorts of fun facts about your SQL Server instance. As last checked today (6/29/2017) the latest CTP build seems to have problems reading the log.
Time saving trick for PowerShell and CMD
Real quick and simple post for today. Having grown up with a computer since the 80’s, I can tell you I still love DOS. In fact, I even have MS DOS mobile on my #WindowsPhone.
SQL Server Monitoring: Creating your own metrics
The one and only important factor in monitoring is data. How much of x and how little of y? If you don’t know these values then you’re shooting in the dark. Microsoft has done a great job adding critical data points over the years; but, what happens when the data you need doesn’t exist?
DBA 101: Tuning lookups
Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a wide variety of indexes; but, today we’re going classic and talking about Non-clustered indexes.
Query tuning 101: What’s a probe residual?
Query tuning is an important process that will probably never go away and sharpening your tuning skills is always a good idea.
I’ve spoken on this topic many times and talked about probe residuals before. Mostly at SQL Saturday events and for some online webinars.
DBA 101: Comparing two SQL plans
Simple post today: How to compare two plans in SSMS.
This task is a task that is often done by a DBA or developer who is wanting to compare changes of an index or perhaps even comparing queries between DEV and PROD.
T-SQL Tuesday: Finding issues with your query plan
This is my first time blogging with a T-SQL Tuesday topic. If you follow my blog you’ve probably noticed that one of the topics I enjoy the most is performance and query tuning.
While at Microsoft, I learned a lot from a lot of great people, such as Joe Sack, David Pless, and Tunji O. I try to pay forward the knowledge that these great people have bestowed on me.
SQL TECH BLOG 