SqlCredit – Part 9: Message Authentication Codes
This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers searching encrypted data, dictionary attacks, and look-ups by hashed value.
2007-10-01
1,557 reads
Articles
The Puzzle of 'Rating Decomposition'
When reading rating information, how do you you knew how many points each separate voter gave if you only know the average rating and the number of votes? Well, you might be surprised to learn that you can figure it out using SQL
2007-10-01
1,919 reads
Conditional Statements in WHERE Clauses
T-SQL is a powerful language, enabling you to handle many different types of set based operations. But having flexible WHERE clauses isn't something that many DBAs deal with on a daily basis. New Author Sotiris Filippidis brings us an article on how you can structure a WHERE clause to handle all types of strange business logic without using dynamic SQL. Read on to learn more about his technique.
2007-09-28 (first published: 2004-07-26)
40,152 reads
Moving the SQL 2005 System Databases
Most SQL Server instances are installed with the default values, but that's not always the way it should be. Often there is the need to "move" databases to comply with standards, free up disk space, or some other reason. Moving the system databases can be a little tricky, but author Vince Iacoboni brings us his code and technique for easily doing this for SQL Server 2005 databases.
2007-09-28 (first published: 2006-09-26)
35,773 reads
Isolation Levels in SQL Server 2005
Isolation levels are used to prioritize the acccess to a resource. SQL Server 2005 extends upon the support for isolation levels in 2000 with several new features including an additional level.
2007-09-28
4,452 reads
SqlCredit Part 8: Comparing Encrypt/DecryptByCert and Encrypt/DecryptByKey
Continuing with this series looking at encryption functions.
2007-09-28
2,381 reads
Beginning Professional Development
Continuing with his series on professional development, Andy Warren takes a look at funding some of your career growth and why it pays to invest in yourself.
2007-09-27 (first published: 2006-09-25)
5,618 reads
Newsletter Changes
A few proposed changes to the newsletter. Read about them and give us some feedback on what you think.
2007-09-27
590 reads
Reverse Engineering ADTs in SQL Server 2000 - Part 3
Continuing on with his series on ADTs, Yakov Shlafman takes a look at working with schema changes when your ADT is on a column used as a primary or foreign key.
2007-09-27
2,241 reads
Avoid enclosing Indexed Columns in a Function in the WHERE clause
When a function is wrapped around an indexed column in the WHERE clause it will usually prevent the proper usage of that index. This article gives an example and discusses what other options are available.
2007-09-27
5,005 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
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...
Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)
Hello all, I’m looking for advice on how to derive a daily snapshot table...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.key
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers