SQL Server Training at TCU
If you are near Texas Christian University, you might want to check out this training from a SQL Server MVP.
2007-12-20
1,558 reads
Articles
SQLServerCentral Rules of Conduct
Being a part of the community means that there are certain standards that we'd like you to adhere to. Steve Jones brings you a few reminders of how to behave when posting in the community.
2007-12-19 (first published: 2007-01-01)
3,142 reads
XML Workshop XIII - XSD And Variable Content Containers
Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.
2007-12-19
3,871 reads
RAID Scaling Charts, Part 3: 4-128 kB Stripes Compared
This is the third article that deals with analyzing the various possibilities involving various RAID setups and differing numbers of hard drives. We used the same hard disks again here: eight Samsung HM321KJ SATA/300 drives powered all of the possible RAID 0, RAID 5 and RAID 6 setups, with from three to as many as eight hard drives configured to use stripe sizes of 4 to 128 kB.
2007-12-19
2,353 reads
Serve SQL Data in XML Format
Ivan Pepelnjak describes a few ways to extract data from SQL databases and serve it to an AJAX application running in a web browser.
2007-12-19
2,780 reads
Login creation in SQL Server 2005 for SQL Server Authentication Mode
Its a graphical representation of login creation in SQL Server 2005 for SQL Server Authentication Mode.
2007-12-18
10,628 reads
Usages of CONTEXT_INFO
How many of you have ever used SET CONTEXT_INFO in your SQL Server applications? Chances are it is not something you have been exposed to, but new author Yousef Ekhtiari brings us an example of how this particular construct can be used in your application.
2007-12-18 (first published: 2006-12-21)
16,977 reads
RAID Scaling Charts, Part 2: RAID 5 And RAID 6
For our RAID tests, we once again use Samsung HM321KJ SATA/300 drives. This time, we benchmarked RAID 5 and RAID 6 setups with three to eight hard drives.
2007-12-18
2,724 reads
Using the DATE data type in SQL Server 2008
In SQL Server 2008 we get a new DATE date type that allows you to store a date without a time.
2007-12-18
4,179 reads
Toward Integrity Part 3
An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.
2007-12-17
3,460 reads
Blogs
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
Using AI for Git Hooks
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Forums
SQL Agent job running gMSA cannot backup to NAS target
I'm running a group MSA for the database engine and SQL Agent in a...
sys.query_store_query question
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Encoding Strings
Comments posted to this topic are about the item Encoding Strings
Question of the Day
Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers