Call for Speakers - SQL Saturday Pittsburgh
SQL Saturday #315 in Pittsburgh (Oct 4th) is looking for speakers - if you've got a SQL topic you want to talk about, submit it and you may get to share with your peers.
How to test what a SQL Server application would do in the past or in the future with date and time differences
For date and time based testing, I use what I like to call "mock-time". The mock-time starts at what ever I set it to, but then advances along with the regular system clock. Andy Novick shows how that would work.
SQL Monitor Custom Metric: Schema Modified
This metric creates an alert that will be raised when something is added to the schema, or the existing schema is modified.
A DBA at the Opera
In opera, tragedy or absurdity happens because the characters are incapable of standing back, and making a difficult decision. Instead, at every stage, they just drift towards their fate by taking the easy option. Don't let the same fate befall you, as a DBA.
Technology Wave
The quickness at which technology has and is changing our lives and shaping our culture.
Call for Speakers in Sunny San Diego
If you're in Southern California, you should come to SQL Saturday #340 and speak at their event. If you want a late summer vacation, submit and come enjoy the event.
Managing Big Data DBAs
Technical support teams usually support familiar hardware and software configurations. Specialization in particular combinations of operating systems and database management software is common, and this allows some team members to gain in-depth experience that is extremely valuable in an enterprise IT setting. How has big data changed this paradigm?
How To Write An Interview Winning Resume
Writing a resume that rocks is not an art. Follow these simple guidelines to help secure your next interview.
Using Views
Views can be a great way to abstract away details for clients, but they can also make development much more flexible.
Create First SSRS Report with SQL Server Analysis Services OLAP Cube
Mubin M. Shaikh outlines how to create SSRS Report on SSAS OLAP Cube. If you don't have much prior knowledge of SSRS, just follow the steps and to have your first report ready on OLAP Cube.
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers