How to Deal with the Stresses and Anxieties in Today's IT Industry
Today we have a guest editorial from Stanley Popovich that talks about dealing with stress at work.
2011-03-28
250 reads
Editorials
Patch Week
With SQL Server releasing new cumulative updates this week, Steve Jones talks about the patching strategy of SQL Server.
2011-03-28
347 reads
What Differentiates Enterprise?
This Friday Steve Jones asks you about the Enterprise Edition of SQL Server, and what should the distinction be?
2011-03-25
208 reads
Do You Need A Safe Word?
A hacker breaches security by gaining control of an executive's email account. Does that mean that we should consider adding another level of authentication to privileged requests?
2011-03-24
160 reads
The Business - Part 2
Today we have a guest editorial by Andy Warren. This one continues the thought of how you relate to the rest of your company, or "the business" as is it often known.
2011-03-22
109 reads
If you could stop working tomorrow, would you still do SQL?
Rodney landrum wonders what, if anything, you would do in SQL, or any other beloved technology, if you did not have to?
2011-03-21
238 reads
Test Before Deciding
How do you decide what improvements to make to your SQL Server? Or what settings to turn off? Having hard and fast rules isn't a great idea, and Steve Jones talks about why.
2011-03-21
181 reads
Looking at SOX
This Friday Steve Jones asks what impact the Sarbanes-Oxley act has had on your job. After nearly a decade since the act was passed, is it intrusive in the workplace or just another part of your job.
2011-03-18
158 reads
Implicit and Explicit Conversions
Code that depends on implicit conversions can live for years in production without issue. However Steve Jones says that you shouldn't depend on these conversions
2011-03-17
454 reads
The Business
How is your IT relationship with "the business"? Andy Warren asks today if there is a real client relationship between the implementers of technology and the consumers.
2011-03-16
260 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
Two queries work until compared with EXCEPT statement
I've got multiple databases on 2 SQL 2019 CU32 servers , all using the...
STRING_AGG DISTINCT
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
In-place OS upgrade or migration to new OS?
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers