Testing for NULLS in a Dataset Filter
Some seemingly simple filtering logic can be more difficult to achieve when using
a dataset filter rather than the WHERE clause...
2010-08-30
620 reads
Blog Posts
Upcoming PASS Performance Virtual Chapter Presentation
I’ll be doing an introductory level presentation on statistics for the Performance VC on September 7th, details and the LiveMeeting...
2010-08-30
1,673 reads
Upcoming Presentations: #24HOP & #SQLSAT46
Blogging has been a bit quiet of late. That’s because I’ve been spending a lot my spare time getting ready...
2010-08-30
765 reads
Dynamic SQL and Cached Query Plans
Over the many years that I’ve been dealing with SQL Server, I’ve always been told and read about how using...
2010-08-29
600 reads
MDX Puzzle #7
I have presented you with a couple of easy puzzles in the last few posts. So, let's step it up...
2010-08-29
477 reads
Restarting SQL Server using a Batch Script
In a previous post, I showed you how one could Restart, Stop and Start the services for an instance of...
2010-08-29
13,245 reads
Restarting SQL Server using the GUI
Sometimes you may need to restart your instance of SQL Server. You should rarely do this on Production boxes, but...
2010-08-29
488 reads
Jax Code Camp - My Presentation and Projects
First and foremost, I want to thank everyone who attended my presentation today. It got off to a late start due...
2010-08-28
421 reads
Microsoft Offers New Certification Exam Discount
If you are intending to take any Microsoft Certification tests soon, you are in luck, because Microsoft has recently introduced...
2010-08-28
1,267 reads
Connectify
It’s a wired world. You’d think by this point, most major hotels, at least those costing upwards of $100/night, would...
2010-08-27
1,043 reads
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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...
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