Go Get an iPhone
This week Mobile BI is on the radar at Microsoft. Steve Jones comments on what this might mean for the database people in the future.
SQL Server 2008 T-SQL Enhancements Part - V
The fifth installment of Arshad Ali's series examines the spatial data types in SQL Server 2008. These new types allow the use of geospatial data in SQL Server applications.
What Data Should You Protect?
Perhaps we need to protect more data, according to Steve Jones. With the ability to identify most people with 10 digits of information, Steve Jones asks you to really think about what you need to store.
Building Code that Promotes Plan Re-usage
This article, the third in the T-SQL Best Practices series, discusses how to write your code to promote cached plan re-usage. Understanding how white space and comments impact whether a plan is cached or an existing plan is re-used can help you minimize the number of plans your application is caching.
How to find, compare and use the exact same session settings as another user in SQL Server
When diagnosing issues in SQL Server I've found that sometimes I need to be able to mimic a user's session state when attempting to repeat an error they may be receiving. The smallest differences can completely change the outcome, so I need to ensure all the session settings (QUOTED_IDENTIFIER, ANSI_NULLS, and so forth) are identical between the production session and my test session. Is there an easy way to determine these settings with a single query?
What Data Should You Protect?
Perhaps we need to protect more data, according to Steve Jones. With the ability to identify most people with 10 digits of information, Steve Jones asks you to really think about what you need to store.
What Data Should You Protect?
Perhaps we need to protect more data, according to Steve Jones. With the ability to identify most people with 10 digits of information, Steve Jones asks you to really think about what you need to store.
What Data Should You Protect?
Perhaps we need to protect more data, according to Steve Jones. With the ability to identify most people with 10 digits of information, Steve Jones asks you to really think about what you need to store.
Work Habits
I enjoy woodworking as a hobby and as I try new things I find that my work habits during the...
Changing of the Guard
This Friday's poll looks at security and password changes. What interval do you think is appropriate and why? Steve Jones asks and gives you a few thoughts on his own experiences.
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