Less Pay, More Convenience
Steve Jones talks telecommuting today as a recent survey shows that a third of IT professionals would take less pay to work away from the office.
Performance Troubleshooting with Windows Resource Monitor - Part 2
In the second part of the Resource Monitor series we conclude with a look using the Memory tab and Disk tab to diagnose performance issues.
Cam-Graph
A new project from Microsoft Research has Steve Jones interested. It deals with large data sets to perform graphical modeling. The storage mechanism has Steve Jones interested.
How to Setup Report Parameters to Default Based On User Credentials
This article explains how to setup Reporting Services (SSRS) parameters default values using user credentials.
Life is Short
Life is short, and Steve Jones reminds us to live for today, even as we invest in ourselves for the future.
Backup and Restore of an Analysis Services Database
One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user and system databases. In this article we will take a look at the steps which a database administrator needs to follow to backup and restore an analysis services database.
SQL Server 2008 R2 Service Pack 1 Customer Technology Preview Available
You can help test the first service pack for SQL Server 2008 R2 and ensure the highest quality possible for its release.
Happy Easter 2011
It's Good Friday and the Easter holiday weekend with a number of countries having a bank holiday. Steve Jones is on vacation and providing us with a blooper reel for today.
ShowPlan Operator of the Week - Split, Sort, Collapse
'Split, Sort & Collapse' is, happily, not a description of the intrepid Fabiano Amorim after his epic series of articles about the ShowPlan operators. With renewed stamina, Fabiano continues his mission to describe all the major operators by explaining the Trivial Plan and the power of unique indices.
Saying Thank You
After a bad experience traveling, Steve Jones stops to recognize that despite a possible computer bug, he still recognizes that the programmers building web sites aren't making mistakes on purpose and deserve a thank you for their work.
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