What Counts as Work - in Software Development
Bill explores the consequences of people not seeing the value in doing things that are crucial to the success of projects.
SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns
SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appropriate high availability and disaster recovery solution for your application. This article looks at the common design patterns.
Forum Etiquette: How to post data/code on a forum to get the best help
Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.
New SQL Monitor Custom Metric: Default TCP Port
This metric checks whether your SQL Server installation is using the default TCP port. It’s widely known that SQL Server 2005 and 2008 listen on TCP port 1433. Keeping this default gives hackers a potential way of attacking your server.
PowerShell Data Basics: File-Based Data
One of the frustrations of anyone beginning with PowerShell is the simple task of getting data in and out. To help out with this, Michael Sorens begins a series that shows you how to import data from most of the common file formats and sources. He also shows how to export data in a range of formats.
A few reflections on RBAR by a weary application developer
Follow the guidance of your DBA, but remember, he or she is from another land.
Nominations open for the 2013 Tribal Awards
SQLServerCentral and Simple-Talk are co-hosting the Tribal Awards. Nominations open today for each of the 11 categories which recognize technical excellence, willingness to help the wider community, and exceptional SQL Karaoke skills.
The 2013 Tribal Awards
The inaugural 2013 Tribal Awards kick off today and Steve Jones has a few thoughts.
SQL Server Database Backup and Restore with Windows Azure Blob Storage Cloud Services using T-SQL Commands
SQL Server 2012 introduces a new feature to issues backups on the Windows Azure Blob Storage service directly and restore from there when needed. But how does it work and how to get started using T-SQL commands for backup and restore operation?
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