SQL Server database design disasters: What not to do
Inspired by what he recently found in some SQL Server shops, database architect Brian Walker shares advice for improved database design – and SQL Server performance.
2008-10-08
5,952 reads
Articles
Parameterizing SSRS Reports - SQL School Video
MVP Brian Knight continues with Reporting Services in this SQL School video that shows you how you can add parameters to your Reporting Services report to customize them.
2008-10-07
5,206 reads
The South African SQL Server Usergroup is Back
MVP Gail Shaw has restarted the South African Usergroup. Read on if you are interested in participating.
2008-10-07
664 reads
Disabling a Trigger for a Specific SQL Statement or Session
I want to suppress the trigger from firing for a particular statement while it remains in its normal execution state for any of the other statements. Is there any way this can be done dynamically?
2008-10-07
4,550 reads
Take the Plunge
Today Steve Jones talks about starting your own business and should you do it with online tools.
2008-10-07
65 reads
Take the Plunge
Today Steve Jones talks about starting your own business and should you do it with online tools.
2008-10-07
88 reads
Take the Plunge
Today Steve Jones talks about starting your own business and should you do it with online tools.
2008-10-07
71 reads
SQL Server PowerShell Extensions (SQLPSX) Part 1
Powershell is the new management interface for scripting and working with SQL Server that is integrated into Windows 2008 and SQL Server 2008. The author of a Codeplex project introduces some extensions that try to make it easier to use Powershell with SQL Server.
2008-10-06
18,391 reads
A Better Database Engine
How much different can a database engine make to a platform? MySpace was recently mentioned along with database technology from Sun Microsystems that might make them more profitable.
2008-10-06
74 reads
A Better Database Engine
How much different can a database engine make to a platform? MySpace was recently mentioned along with database technology from Sun Microsystems that might make them more profitable.
2008-10-06
73 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...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
Data Modeling with dbt for Visual Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Data Modeling with dbt for...
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