The Tethered Goat
Phil Factor's a 'tethered goat' database taught in the value of database intrusion detection and of "defense in depth".
Using Super Keys to Enforce Database Constraints
Example of Using Super Keys to Enforce Database Constraints, instead of procedural code
SQL Server Management Studio Recovery, Reporting, Key Combinations and Efficiency Tips
Serget Gigoyan is back with another set of 5 common SSMS tips.
Dynamic Pivot, Passing Temp Table Variables to Dynamic SQL
This example demonstrates how to perform a pivot using dynamic headers based on the row values of a table. The article also shows how to pass a temp table variable to a Dynamic SQL call.
Developing Metadata Design Patterns in BIML
You may have already experienced ETL Hell, where you have a large number of similar of SSIS tasks, and a small change, such as an alteration to the network topology, means that they all need to be altered with the correct connection details. Perhaps you should consider creating design patterns for all the standard components of integration tasks in BIML, and generating the SSIS packages from these? Amarendra walks you through the process.
The Second Best Job
Redgate is hiring someone to manage Simple Talk, a job just like the one Steve has with SQLServerCentral.
Ingest data from a web page into SQL Server 2017 using R
Siddharth Mehta shows that R libraries can be used from T-SQL to ingest data from the web into SQL Server.
Performance Myths : Oversizing string columns
Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kantor Bank BCA KCU KEDIRI Telp:08218154393
WA:08218154393 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
Alamat Kantor Bank BCA KCU MALANG Telp:08218154393
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers