Reblog: The OLE DB Source and the Oracle Date Literal
SQLKover update:when of the stranger Oracle issues I encountered over the years. Some time after I published the original blog...
2015-08-06
817 reads
Blog Posts
SQL Server Audit: Getting Started
SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature. Audited...
2015-08-06 (first published: 2015-07-28)
3,472 reads
A pattern to match correctly on a value or a NULL
As you may have noticed if you read my blog I learn a lot from trolling various forums. In this...
2015-08-05
1,304 reads
Architecture VC AlwaysOn Questions Answered
On July 15th, 2015 I spoke to the PASS Architecture Virtual Chapter about AlwaysOn Failover Cluster Instances and AlwaysOn Availability...
2015-08-05
1,152 reads
DBTA – StretchDB, a Cool New Feature in vNext SQL Server
Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader,...
2015-08-05
17 reads
Halloween at PASS–Donate for some fun
This year’s PASS Summit will end on Oct 30, which is just before Halloween in the US. I’m sure lots...
2015-08-05 (first published: 2015-07-29)
1,912 reads
Kerberos Configuration Manager for SQL Server v3
By David Postlethwaite
I’m speaking about Kerberos for the SQL DBA at SQL Saturdays in Oslo, Gothenburg and Utrecht in September...
2015-08-05
2,269 reads
PASS Needs You!
It’s time.
No more procrastinating. No more complaining about the process from the outside. No more excuses.
You have to run for...
2015-08-05
580 reads
Synchronous Processing in the SSIS Script Component
Without a doubt, the most versatile data flow tool in the SSIS arsenal is the script component. This control grants...
2015-08-05 (first published: 2015-07-29)
2,898 reads
Using Kickstarter to Save Neil Armstrongs Spacesuit
Ran across this while visiting the Air & Space Museum over the summer, the Smithsonian launched a Kickstarter campaign to raise...
2015-08-05
677 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers