Creating a Date Dimension (Calendar Table) in SQL Server
Learn how to create and populate a Date Dimension table in SQL Server
2025-04-14
110 reads
SQL Server
Elements of the SQL Server Update Statement
Learn how to use the UPDATE statement, along with a few things to be aware of when changing data.
2025-04-11
1,171 reads
Improving the Performance of UPDATE Statements in SQL Server
Learn how to optimize UPDATE performance in SQL Server by examining three different methods of making large updates.
2025-03-26
5,602 reads
Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions
Learn how to use the LEFT_SHIFT and RIGHT_SHIFT bitwise functions in SQL Server 2022.
2025-03-19
4,354 reads
How to Download and Restore AdventureWorks 2019 Database
Learn how to download and restore AdventureWork 2019 Database.
2025-03-07
821 reads
Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions
Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the key challenges in this field is determining whether a specific location falls within an area of interest. This capability is especially valuable for property and casualty (P&C) insurers, who need to assess their insured property exposure when severe weather events such as tornadoes occur.
2025-03-04 (first published: 2025-03-03)
2,484 reads
How to Download and Restore AdventureWorks 2022 Database
Learn how to download and restore the AdventureWorks 2022 database in SQL Server with this step-by-step guide.
2025-02-28
1,232 reads
Understanding Data Type Conversion Functions in SQL Server with PARSE, TRY_PARSE, and TRY_CONVERT
Learn how to effectively use SQL Server's data type conversion functions PARSE, TRY_PARSE, and TRY_CONVERT
2025-02-07
2,095 reads
Attaching Multiple SQL Server Databases with DBCC CHECKPRIMARYFILE
Learn how to quickly and efficiently attach multiple SQL Server databases using the undocumented DBCC CHECKPRIMARYFILE command. Automate the process with minimal effort, saving time and reducing errors.
2025-01-27
1,487 reads
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server
Learn how to avoid common pitfalls when using T-SQL trigonometric functions in SQL Server.
2025-01-13
3,109 reads
Blogs
Why use XACT_ABORT?
This came up one day at my work when a developer was using it....
Using AI for Data Conversion
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
Advice I Like: Tipping
By Steve Jones
When in doubt, overtip – from Excellent Advice for Living This is close to...
Forums
How Much AI Code Would You Use?
Comments posted to this topic are about the item How Much AI Code Would...
Browsing for Instances
Comments posted to this topic are about the item Browsing for Instances
Creating a Date Dimension (Calendar Table) in SQL Server
Comments posted to this topic are about the item Creating a Date Dimension (Calendar...
Question of the Day
Browsing for Instances
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers