Custom TDS Endpoints: Listening on multiple ports
Last time, I talked about how clients communicate with SQL Server through TDS endpoints and how to disable endpoints to...
2012-04-18
2,171 reads
Blog Posts
Log shipping setup problem
Last week, our log shipping setup had a problem, so I spent some time to dig into the log shipping....
2012-04-18
2,612 reads
Microsoft Certified Solutions Associate – SQL Server 2008 Core / Windows Server® 2008
Yesterday, I received two mails from the Microsoft Certification Program Team about two new certification earned:
1. Microsoft Certified Solutions Associate...
2012-04-18
1,712 reads
PASS Data Arch VC presents Mike Fal: Eating the Elephant: SQL Server Table Partitioning
Thursday’s (May 17th, 2012) PASS Data Architecture Virtual Chapter has Mike demonstrating some cool Table Partitioning scripts which I was...
2012-04-18
556 reads
Professional Productivity Books
Just as with the "soft skills" books, in my professional development presentation, I list the professional productivity books that I have found most helpful in my...
2012-04-18
912 reads
SQL Injection Tools
I wouldn’t recommend you use any of the tools in this article for attacking anyone, but they could help you...
2012-04-18
1,240 reads
SQL Server 2012: Certification Upgrade Info
As a follow-up to my SQL Server 2012: New Certification Info, Microsoft Learning has announced the certification tracks for the SQL Server...
2012-04-18
7,443 reads
sys.sql_modules vs. INFORMATION_SCHEMA.Routines
Consider the following two queries meant to search for a keyword in SQL programmability objects.
select s.name +'.' + o.name, o.type_desc, m.definition
from sys.sql_modules...
2012-04-18
1,976 reads
Urgent BIOS Update for Dell PowerEdge R810, R910 and M910 Servers
If you have an 11th generation Dell PowerEdge R810 , PowerEdge R910 server, or a PowerEdge M910 blade server, there is...
2012-04-18
2,173 reads
Visualize Wait stats with Microsoft Excel
In our blog post last week: Instance Wide Wait Stats we promised to show You how to visualize the collected...
2012-04-18
1,179 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