Email In The Bathroom: Not A Universal Good
Here are some fine, affordable products to completely destroy your work-life balance.
Learn Continuous Integration for Databases in Bellevue, WA
Redgate Software has teamed up with Northwest Cadence to present a workshop on May 15, 2015. Come learn how to implement continuous integration in your database development software pipeline.
Time Testing SQL Azure Point In Time Database Restores
If you need to do a time test for restoring an Azure SQL database from a point in time, and wonder about automating this through PowerShell, here are the guidelines that Tim Smith would you recommend?
Understanding Cross-Database Transactions in SQL Server
Microsoft 'Always On' technology does not support distributed or cross-database transactions. Why not? Grahaeme Ross shows how to investigate cross-database transactions to understand the problem in more detail, and concludes that a Cross-Database transaction can cause loss of data integrity in the commit phase of the two-phase commit.
Your Role Is Changing
The DBA role is changing with the growth of DevOps as a way to better build software in an organization.
Continue a Foreach loop after an error in a SQL Server Integration Services package
Say you have a SQL Server Integration Services (SSIS) package with a Foreach Loop container. Inside that container you have a task that sometimes can fail. Koen Verbeeck provides a tip on how to implement SSIS so that, if it fails, the loop will just continue, skip the current step and go to the next iteration.
Webinar: Wait, what exactly are we shipping? Keeping control in database continuous delivery
Join us on Tuesday 28th April at 4pm BST (11am EDT) for a free webinar panel discussion featuring Brian A. Randell, Grant Fritchey, Steve Jones, and host, Stephanie Herr, on the topic of maintaining visibility and control in database continuous delivery.
Security Through Chaos
A company Steve Jones knows uses a diverse network infrastructure to help provide security.
Schema-Based Access Control for SQL Server Databases
Access-control within the database is important for the security of data, but it should be simple to implement. It is easy to become overwhelmed by the jargon of principals, securables, owners, schemas, roles, users and permissions, but beneath the apparent complexity, there is a schema-based system that, in combination with database roles and ownership-chaining, provides a relatively simple working solution.
Data Mining Part 26: Introduction to Cubes
In this tutorial we will explain what are the SSAS cubes to use them in Data Mining.
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
Alamat Kontak BCA KCU DAAN MOGOT Telp:0817819444
Wa:0817819444 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers