|
|
Latest Blog Posts
-
 |
|
133 Views |
In the efforts to protect sensitive data there are some considerations that expand beyond its storage within database; more specifically, the backup files that are generated through the database backup process. Backup files are often kept on devices or...
|
-
 |
|
247 Views |
At last night's Information Design Association presentation, David Sless talked about benchmarking research for credit card statements. This was quite interesting. Almost as interesting was that he seemed at near circumloquitous pain to avoid the word...
|
-
 |
|
968 Views |
When Database Mirroring was introduced in SQL Server 2005, it seemed reasonable to assume that log shipping would gradually go out of fashion. Mirroring is a way of introducing high-availability to SQL Server by allowing the secondary server to become...
|
-
 |
|
438 Views |
Through the development of ANTS Memory Profiler 5, we realised that the
most serious barrier to customers wanting to buy memory profilers was
how complex and hard-to-understand memory profiling is.It
happened that, for other reasons, I'd architected...
|
-
 |
|
1019 Views |
What makes an exceptional DBA? It depends on who you ask. In his book, How to become an Exceptional DBA, Brad McGehee gives his perspective on what it means to be a DBA, and the skills and traits that distinguish the exceptional DBA. It is the first time...
|
-
 |
|
408 Views |
In the boardroom that morning it almost seemed as if our company was staging a re-enactment of a Stalinist show trial. Across from me sat my beleaguered colleagues, their sullen and despondent faces trembling in terror as my CEO digested the dismal sales...
|
-
|
|
302 Views |
Creating a symmetric key for the use of protecting other keys or directly encrypting sensitive data is accomplished through the execution of the CREATE SYMMETRIC KEY command. One of the arguments to this command is WITH ALGORITHM which provides the means...
|
-
 |
|
509 Views |
During our usability trials for ANTS Memory Profiler 5, one of our customers said that to do memory profiling "you'll need a PhD and two days set aside." Hmm... ANTS Memory Profiler 5? 2 days and a Phd?!? More like an hour and a half, and maybe some coffee,...
|
-
 |
|
292 Views |
There've been a lot of interesting articles about PowerShell on Simple-Talk lately, but when I brought the topic up in conversation with our SysAdmin here at Red Gate, I discovered that not all technical masterminds think in command-line statements. I...
|
-
 |
|
782 Views |
We know that Oracle developers and DBAs face many of the same challenges as those who work with SQL Server. We know it's frustrating to compare and deploy database schemas across different environments. And we know that we can help – but only if we take...
|
-
|
|
1035 Views |
DBAs, like many other IT professionals, often take instruction in how to do their job from people who have no recent experience in their profession. How has this come about? Such is the huge task of assimilating and ordering facts about any new technology...
|
-
|
|
731 Views |
I was recently strolling through some of my old blog entries from my pre-Simple-Talk days for inspiration. I ran across an entry on the ISNUMERIC function that I thought that worth re-posting. Enjoy! SQL Server 2005 Books Online describes the ISNUMERIC...
|
-
 |
|
676 Views |
I write a lot of comments in my code: these days it's second nature. Every declaration I write has a comment describing what it's for and maybe some remarks describing things I think are the associated gotchas. Inside method definitions, I maintain a...
|
-
 |
|
522 Views |
I have spoken at many conferences over the years, including the PASS Community Summit and SQL Server Connections, and one of the things I have noticed is that there is very little overlap between the DBAs and developers who attend each of these conferences....
|
-
|
|
611 Views |
Both release candidates are now available, both work with CLR 4.0, and we've got a funky new YouTube channel containing tutorial videos for both. Check it out......
|
-
 |
|
1498 Views |
With the kickoff of nominations for 2009's Exceptional DBA Awards about two weeks away, it's a good time to revisit the challenges faced by last year's nominees and solicit opinions on whether they are still valid.
As a communications consultant in 2008's...
|
-
|
|
1083 Views |
Microsoft's recent policy of Glasnost has meant that we now enjoy direct, technical communications about their products from the people responsible for building them. In the bad old days, when all communication was filtered through the obfuscating glass...
|
-
|
|
425 Views |
I have been subscribing to the OSF Data Loss Feed for well over a year. This feed provides me with brief blasts of information about data loss events that are reported around the world. These data loss events consist of sensitive data that is stolen,...
|
-
 |
|
1442 Views |
Stan, the SQL Hero, had a meteoric career at the large Financial Services Company where I worked. He burned red-hot when he hit the upper atmosphere of the company, and caused a brief flash before hitting the ground. ...
|
-
|
|
1471 Views |
One of the most interesting throw-away lines at the recent TechEd show was that Entity Framework was about four times slower than LINQ for SQL, because Entity Framework was a generic solution that could be used with a variety of data stores, and wasn't...
|
-
|
|
1065 Views |
To the huddled masses of men it was as if the God of war himself had stage-managed the scene. As the thunder of the guns died away, a light breeze suddenly sprang up and began to carry away the clouds of smoke obscuring the battlefield, revealing the...
|
-
|
|
464 Views |
We’ve finally done it! We’ve released our Exchange archiving tool after 18 months of research, development, usability studies and testing. 219,115 Lines of code 19,485 Subscribers to Simple Talk Exchange 15,144 Words of documentation...
|
-
|
|
806 Views |
There are many good reasons to protect the sensitive data that is in your database: government regulation, corporate policy, managing legal liability and simply being a good steward of the information that has been entrusted to you. There are also industry...
|
-
|
|
1485 Views |
Red Gate’s performance and memory profilers may have gone through a complex and protracted divorce, but they’re still the best of friends......
|
-
|
|
2028 Views |
It has been obvious for a while that Powershell 2 was going to be strongly supported as the natural scripting language for Windows Server 2008 R2 and Windows 7. It comes with interesting new features, such as the ability to execute scripts on remote systems...
|
|
|