Adding a Linked Server with ‘Oracle Provider for OLE DB’ as the provider – Proceed with caution !
Adding a linked server is an easy task which can be done at any point of time. I was under...
2013-03-13
2,928 reads
Blog Posts
Atlanta MDF Presents Five Pre-Cons to choose from in Atlanta Friday, May 17
SQL Saturday is returning to Atlanta on May 18th at Georgia State University – Alpharetta, 3775 Brookside Pkwy, Alpharetta, GA 30022
The...
2013-03-13
196 reads
Atlanta MDF Presents Five Pre-Cons to choose from in Atlanta Friday, May 17
SQL Saturday is returning to Atlanta on May 18th at Georgia State University – Alpharetta, 3775 Brookside Pkwy, Alpharetta, GA 30022 The day before the event Atlanta MDF is...
2013-03-13
8 reads
Cleaning orphaned SIDs after a SQL Server VM template deployment
A few weeks ago (or longer, I’m behind on email again) Nate Palm (LinkedIn) messaged me after the most recent...
2013-03-13 (first published: 2013-03-11)
1,662 reads
Find missing indexes using SQL Servers index related DMVs
Today, we experienced performance issues with few databases that are hosted on one of our most critical production SQL Server....
2013-03-13
1,908 reads
Querying Microsoft SQL Server : Basics of Indexes in SQL Server
Querying Microsoft SQL Server : Basics of Indexes in SQL Server: Indexes in SQL Server: If you see a book, in...
2013-03-13
923 reads
Querying Microsoft SQL Server : Basics of Triggers in SQL Server
Querying Microsoft SQL Server : Basics of Triggers in SQL Server: SQL Triggers: A trigger is a procedural code like stored...
2013-03-13
1,470 reads
Querying Microsoft SQL Server : Control Statements in T-SQL
Querying Microsoft SQL Server : Control Statements in T-SQL: Control statements are used to control execution flow within a T-SQL.Here I...
2013-03-13
752 reads
Querying Microsoft SQL Server : Defining Variables
Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your...
2013-03-13
847 reads
Slide Deck–SQL Saturday Exeter
In my session (An Introduction to SQL Server Virtualisation) at SQL Saturday Exeter I told the attendees that I would...
2013-03-13
859 reads
Blogs
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers