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
16 reads
Blog Posts
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
28 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
17 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
23 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)
354 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)
277 reads
Daily Coping 7 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-07
29 reads
Experiments With Go Arrays and Slices
Simplicity Over Syntactic Sugar
As I’ve been learning Go, I’ve grown to learn that many decisions to simplify the language have removed many features that provide more succinct expressions in...
2021-01-07 (first published: 2020-12-30)
333 reads
Game changer settings # MAXDOP and Cost threshold for parallelism
I got a performance tuning assignment for an esteemed customer in the Financial Services domain. I went through the wait stats of SQL Server using the built-in SQL Server...
2021-01-07 (first published: 2021-01-02)
2,778 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers