SQL Homework – January 2020 – Create an End of Year/New Year checklist.
It’s a brand new year and hopefully it will be better than last year. While that may be particularly true ... Continue reading
2021-01-11 (first published: 2021-01-05)
362 reads
Blog Posts
Annual Corporate Report Filing for SQLOrlando
As a Florida corporation we have to file an annual report. Sounds complicated, but for us it’s a five minute task. Here’s the Trello card for the work I...
2021-01-10
24 reads
Annual Corporate Report Filing for SQLOrlando
As a Florida corporation we have to file an annual report. Sounds complicated, but for us it’s a five minute task. Here’s the Trello card for the work I...
2021-01-10
3 reads
Filing the Annual Tax Return for SQLOrlando
Similar to my earlier post on filing the annual report, once a year we have to file a tax return with the IRS. Basically if the revenue is less...
2021-01-10
10 reads
Filing the Annual Tax Return for SQLOrlando
Similar to my earlier post on filing the annual report, once a year we have to file a tax return with the IRS. Basically if the revenue is less...
2021-01-10
27 reads
Connecting to SharePoint Lists with SSIS
SharePoint lists are popular and simple tools for storing modestly-sized discrete sets of data. SQL Server Integration Services (SSIS) includes a source component to allow reading data from SharePoint...
2021-01-09
12 reads
Daily Coping 8 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-08
8 reads
Goal Progress–Wrapping up 2020
This is the final look at my goals for 2020 and how I did. I am writing this a few days after the end of the year, and examining...
2021-01-08
12 reads
Powerful Monitoring for Your Linked Servers with XEvents
Linked Servers can certainly provide an enigma to your finely tuned Database environment. In this article, I share how to decrypt that enigma via XEvents.
The post Powerful Monitoring...
2021-01-08 (first published: 2021-01-02)
353 reads
Saving PASS Pro Videos
PASS will close down their websites on 15 Jan 2021. That’s just a couple weeks away, and if you’re someone that paid for a year of PASS Pro access,...
2021-01-08 (first published: 2021-01-04)
268 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers