Fundamentals of Storage Systems – Capturing IO Patterns
We often take the advice given to us on forums or in articles at face value. Even though the authors...
2009-11-27
3,278 reads
Articles
How to simulate transparent data encryption (TDE) with SQL 2000 and 2005
Encryption of data at rest is becoming more and more crucial in today’s world. This tip is aimed to help businesses that do not have the budgets or resources to purchase hardware encryption tools or to upgrade to SQL 2008. It basically illustrates how to achive transparent file encryption with SQL 2005 or SQL 2000.
2009-11-27
4,390 reads
Increase Your Value as a Professional in the Technical Industry
It has never been so important to enhance your employability as it is today. Job security can never be taken for granted. Employability, increasing your professional value, means far more than just collecting qualifications, as Dr Masha Petrova explains: It also involves communicating, writing, and participating in communities.
2009-11-27
2,850 reads
The DBA Boat
For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.
2009-11-27
831 reads
The DBA Boat
For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.
2009-11-27
1,164 reads
The DBA Boat
For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.
2009-11-27
1,085 reads
4 Ways to Increase Your Salary (Using UPDATE)
This article depicts how to approach row by row updates needed in a salary table. It might not directly let you increase your salary, but it could help you at review time.
2009-11-26
42,878 reads
Happy Thanksgiving 2009
Happy Thanksgiving to everyone in the US. The editorial today has a blooper reel from the podcasts in celebration of the holiday.
2009-11-26
833 reads
Happy Thanksgiving 2009
Happy Thanksgiving to everyone in the US. The editorial today has a blooper reel from the podcasts in celebration of the holiday.
2009-11-26
1,104 reads
Building a Yahoo Finance input adapter for SQL Server StreamInsight
Step by step guide to building and debugging a SQL Server StreamInsight input adapter.
2009-11-25
7,243 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers