Repairing a replication subscriber
It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes...
2015-09-22
1,138 reads
Heading To PASS Summit 2015 – Now What?
You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the...
2015-09-22
330 reads
Heading To PASS Summit 2015 – Now What?
You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the...
2015-09-22
543 reads
Comparison Predicates and Event Data
Predicates are a significant component within the Extended Events Engine. This article discusses one of the pieces of the puzzle of predicates - comparison operators - also known as...
2015-09-22
25 reads
Comparison Predicates and Event Data
In the previous installment, I began covering the topic of predicates. In that article I demonstrated that there are multiple types of...
2015-09-22
837 reads
Finding Next Business Day in T-SQL
Let’s say you have a table that records transactions along with the date of when the transaction took place. Wait,...
2015-09-22
5,207 reads
Most Read: My Top 5 SQL Server Articles and Blogs
There has been some really useful blogs and articles posted over the last week or so, this is my top...
2015-09-22
531 reads
Encrypting Connections To SQL Server Using Certificates
Encrypting Connections To SQL Server Using Certificates In this post we’re going to cover configuring a connection string in .NET applications for encrypting connections to SQL Server using certificates....
2015-09-22
14 reads
Encrypting Connections To SQL Server Using Certificates
Encrypting Connections To SQL Server Using Certificates
In this post we’re going to cover configuring a connection string in .NET applications...
2015-09-22
7,266 reads
Populating My DBA Database for Power Bi with PowerShell – Databases
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-22
864 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers