From “One of the Pack” to “Top Dog”
A guest editorial today from Justin H-Davies examines the change to management from the perspective of someone going through the transition. How do you deal with those former co-workers?
Achieve Spatial Data Support in SSIS
Spatial data support in SSIS is weak in comparison to SQL Server. This article demonstrates how to use the CLR to achieve the SQL Server levels of spatial data support in SSIS.
How to Increase Query Speed With a Little Communication
How my former boss solved a performance issue by changing the business rules, instead of query optimization.
Is it Time to Switch to ELT?
Extract-load-transform integration can offer performance and cost advantages over ETL. Here's how to pick the right approach.
Early July 2010 PASS VC Presentations
In July start with the following presentations from the AppDev and DBA Virtual Chapters of PASS:
Loops, Lookups and Splits: SSIS Beyond the Basics
Why Should I use Stored Procedures?
The Private Cloud
Cloud computing is becoming more and more prevalent in technology. However most people think of a public cloud on the Internet. Steve Jones says a private cloud might be a better idea for many companies.
A closer look at CXPACKET wait type in SQL Server
If you have a server that has more than one CPU core, you may experience high values of CXPACKET wait types. This is typically due to queries that run in parallel and the real issue is to understand how different versions of a query can impact CXPACKET waits. In this tip we examine how changing a query can impact CXPACKET waits.
Copy-and-Paste SSIS Execution Monitoring with Failure-Alert Email
This SSIS package monitors the execution of any SSIS tasks pasted into its sequence container, and sends an email when a failure of any embedded task occurs.
GOSQL vs. NOSQL
If we're getting pulled down a blind alley by acronyms, we may as well make up a more optimistic one.
The Utilty
Is Information Technology a utility service for companies? Steve Jones thinks it can, and should, be, but it can also be a lot more. It can be a strategic part of your enterprise.
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