RedGate Source Control for SQL Server Webinar from Pluralsight
Join this webinar from Pluralsight, a very well known developer training company. Learn how SQL Source Control can help you keep track of your code.
Understanding and Using Parallelism in SQL Server
SQL Server is able to make implicit use of parallelism to speed SQL queries. Quite how it does it, and how you can be sure that it is doing so, isn't entirely obvious to most of us. Paul White begins a series that makes it all seem simple, starting at the gentle level of counting Jelly Beans.
Is Microsoft neglecting SMO?
Phil Fator, the self-confessed wild man of T-SQL, finally comes clean: he's a secret PowerShell user. But for the DBA, what is PowerShell without SMO? Is Microsoft giving the latter the care and attention it needs?
The Wisdom Department
Steve Jones talks about the way business ought to run, with more long term goals and objectives taking precedence over short term revenue. One idea that might help us is having a wisdom department that looks forward and tries to grow the business for the long term.
TSQL Challenge 51 - Convert long Binary strings to Decimal strings
This challenge invites you to write a query that converts binary values into decimal format.
Slow in the Application, Fast in SSMS? Understanding Performance Mysteries
When I read various forums about SQL Server, I frequently see questions from deeply mystified posters. They have identified a slow query or stored procedure in their application. They cull the SQL batch from the application and run it in SQL Server Management Studio (SSMS) to analyse it, only to find that the response is instantaneous. At this point they are inclined to think that SQL Server is all about magic. A similar mystery is when a developer has extracted a query in his stored procedure to run it stand-alone only to find that it runs much faster – or much slower – than inside the procedure.
Coding Standards Part 2 - Formatting
The second part of Steve Jones' series on coding standards within SQL Server.
Concatenating Rows
Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.
SLA Contracts
This Friday Steve Jones talks about the commitments and contracts that you may have with your customers. Do you know what they are? Is the contract explicitly spelled out? Take this Friday's poll and share your answer with everyone else.
Look-up Tables in SQL
Lookup tables can be a force for good in a relational database. Whereas the 'One True Lookup Table' remains a classic of bad database design, an auxiliary table that holds static data, and is used to lookup values, still has powerful magic. Joe Celko explains....
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers