Notes from the May 6th, 2010 oPASS Meeting
We moved to Thursday this month to line things up so that Dean Richards from Confio could do a presentation...
2010-05-11
548 reads
Blog Posts
Put your left LOB in, put your left LOB out…
It’s time again for T-SQL Tuesday and this month the topic is LOB, or BLOB data. You can read more...
2010-05-11
1,915 reads
Recompiles and Constant Learning
When faced with a procedure that looks like this:
CREATE PROCEDURE dbo.TestProc (@TestValue INT)
AS
BEGIN
IF @TestValue = 1
BEGIN
SELECT *
FROM Sales.SalesOrderHeader AS soh
JOIN Sales.SalesOrderDetail...
2010-05-11
773 reads
Simple Production Script Auditing Best Practices: Including Query in the Result Set
To make it easier for others to audit the results of a script you have run on current production servers,...
2010-05-11
1,486 reads
Some New DMV Queries for SQL Server 2008 R2
I was spelunking around in SQL Server 2008 R2 today, after looking at a PowerPoint presentation by Madhan Arumugam about...
2010-05-11
1,784 reads
SQL Server with MS Access .adp Project file
MS Access have a nice possibility if you want to connect with SQL Server databases and manipulate with data in...
2010-05-11
13,859 reads
STS-132 NASA Tweetup or "I've Won A Golden Ticket!"
Note: This is a very non-SQL Server related post. If you don't want to read something personal about me feel...
2010-05-11
852 reads
T-SQL Tuesday #006 Blobs, FileStream and PowerShell
In case you’re wondering about the title T-SQL Tuesday, it’s a monthly collection of SQL Server related content where a...
2010-05-11
4,134 reads
T-SQL Tuesday #006: A Blobbing We Will Go
Once again it looks like I was early for the T-SQL Tuesday event. Last month I submitted my entry on...
2010-05-11
876 reads
Twitter is…
I think Twitter is a graffiti wall that emulates a series of hallway conversations near the world's largest food court.
2010-05-11
699 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