Today’s topic is Pagination. Paging is a really important feature for web pages and applications. Without it you’d be passing large amounts of data to the application and expecting the application code to figure out which rows it needed to display.
Category: DBA
SQL Server vs Oracle: Top N rows
In today’s continuation of the SQL / Oracle series, I thought it’d be nice to show how different the two are for retrieving the top number of rows.
SQL Server vs Oracle: End of Month
Continuing my series on SQL Server and Oracle, I thought I’d highlight a function that has been in Oracle from some time and has only just recently appeared in SQL Server.
SQL Server vs Oracle: Date formatting
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.
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?
If Clippy found his way to SSMS
Recently my wife and I were comparing Cortana with Siri. It’s sometimes fun to compare virtual assistants to see how well they fare. Try asking Siri: “What time is it in GMT?”. We found a lot of others that Cortana knows that Siri doesn’t. This got me thinking. What if Clippy was included in SSMS?
SQL TECH BLOG 