Create an Empty Database Using SQL Server Integration Services
Learn how to create a copy of an existing database without any data using Integration Services.
SQL Prompt Safety Net Features for SSMS: SQL History
Mistakes occasionally happen. Occasionally, you make some ill-judged 'refinements' to working code and now just wish you could rewind your tab back in time an hour and forget the whole sorry episode. Now and again, SSMS just conspires against you and crashes unexpectedly, and you lose all your currently open query tabs, some of which you hadn't saved. SQL History offers a useful safety net in the event of any of these unfortunate events.
Use DDL Triggers to Automatically Keep SQL Server Views in Sync
As much as we tell people to use SCHEMABINDING and avoid SELECT *, there is still a wide range of reasons people do not. A well-documented problem with SELECT * in views, specifically, is that the system caches the metadata about the view from the time the view was created, not when the view is queried. If the underlying table later changes, the view doesn't reflect the updated schema without refreshing, altering, or recreating the view. Wouldn't it be great if you could stop worrying about that scenario and have the system automatically keep the metadata in sync?
Moore's Law: Navigating the Pace of Technological Change
Technology has always been a driving force in shaping our world, propelling us forward into new realms of innovation and progress. One of the most famous concepts in technology is Moore's Law, which suggests that the number of transistors on a microchip doubles approximately every two years, leading to exponential increases in computing power. In […]
Data Oriented Cloud Security Mechanisms
This article looks at security mechanisms in the cloud that can help protect your data, with specific examples in AWS.
The Loss of Knowledge
The loss of developer knowledge can be impactful for an organization. Steve notes that they should do more to retain their staff.
Three Use Case Examples for SQL Subqueries
There are many great tutorials on syntax, performance, and keywords for invoking subqueries. However, I wish to discover a tip highlighting selected SQL subquery use cases. Please briefly describe three SQL subquery use case examples. For each use case, cover how a subquery interacts with outer queries and the T-SQL for implementing the use case. Review excerpts from each example to show the value of implementing the use case.
Big Data Downsides
Too much data, especially for some data analysis isn't good for diversity of any product domain.
SQL Server 2012 Always On Groups and FCIs Part 3
Part 3 of the AO and FCI integration series. This article gets SQL Server configured on the nodes and ready for work.
How to ask for programming help
Over the past 25 years, I have answered a lot of programming questions in online forums, from co-workers, and from friends. It has been a while since I had been around forums, but I recently decided it was time to get back to what started me in the SQL community: answering questions. Not only is it complementary to my current job as Simple-Talk editor, it is really a great joy to be able to help other people with their problems. It is also educational to see the kinds of things other people are going through before you also go through them.
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Telp BCA KCP Central Park Cs 0823-74977784
Wa:082374977784 Ruko GSA Blok Beufort 08 CB CC CD, RT.9/RW.5, South Tanjung Duren, Grogol...
Telp BCA KCP Mandala Raya Cs 0823-74977784
Wa:082374977784 Jl. Mandala Raya No.14, RT.13/RW.5, Tomang, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers