Josef Richberg is an exceptional person: The Judges of the Exceptional DBA Award were quickly proved right in their decision to choose him, when he subsequently showed extraordinary resilience and determination in the face of an unexpected diagnosis of cancer. His determination to deal positively with a difficult life-event is surely a source of inspiration to all of us.
Preparation for upgrading SQL Server 2005 production database servers to SQL Server 2008, I tested upgrade in dev/test env.
Why attend a conference? After the PASS Summit and SQL Connections, Steve Jones shares a few thoughts about the benefits of attending a conference for employees.
Most SQL Server DBAs have questions about how to detach and attach a FILESTREAM enabled databases. In this tip, we will take a look at the steps Database Administrators need to follow in order to detach and attach a FILESTREAM database once Data, Log and FILESTREAM container files have been moved from the default location to a new location. This tip includes a general explanation of the FILESTREAM technology introduced with SQL Server 2008. This is followed by examples and scripts to detach and attach FILESTREAM enabled database in your environment.
I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800...
Why attend a conference? After the PASS Summit and SQL Connections, Steve Jones shares a few thoughts about the benefits of attending a conference for employees.
Why attend a conference? After the PASS Summit and SQL Connections, Steve Jones shares a few thoughts about the benefits of attending a conference for employees.
Why attend a conference? After the PASS Summit and SQL Connections, Steve Jones shares a few thoughts about the benefits of attending a conference for employees.
Does a programmer need to know how his code gets executed? Arguably, developers should focus on database structures rather than a particular implementation, and Phil tries to convince us that good programming is not just knowing everything about your programming environment.
It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
I have a couple of SQL Agent job steps which run PowerShell commands of...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
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