Unit Testing, Databases, and You
As database changes are added to the DevOps pipeline, unit testing of those changes becomes crucial. In this article, Adam Hafner describes unit testing and how it applies to databases.
2019-06-06
Articles
Monitor SQL Server Integration Services Packages Stuck in Running Status
In this tip we look at a script to find SSIS packages that are stuck executing and how to end the package execution.
2019-06-05
SQL Server Triggers Pros and Cons
In this tip we look at some of the advantages and disadvantages of using triggers in SQL Server.
2019-06-05
A Plunge Into TOP
Introduction TOP is one of the many syntactical operators available in T-SQL and at a first view, it could seem very simple and not particularly interesting. According to the official documentation, it “limits the rows returned in a query result set to a specified number of rows or percentage of rows”. The following is the […]
2019-06-04
5,179 reads
How to Eliminate Gaps in Identity Values in SQL Server by Disabling the Identity Cache
Learn how to remove gaps in Identity values in SQL Server caused by Identity Cache.
2019-06-04
SQL Clone for Unit Testing Databases
Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit test your code, messing up the clone in the process, then reset the clone in seconds, ready for the next test.
2019-06-04
SQL Server Common Table Expression vs Temp Table
In this tip we look at how to use Common Table Expressions CTE in SQL Server including the syntax, use cases, using more than 1 CTE at the same time and recursive CTEs with a parameter.
2019-06-04
Create and deploy Azure Resource Manager templates by using the Azure portal
This article will explain and help to create and deploy ARM templates using the Azure portal. When Azure was first created, Azure resources were managed using the Azure service management (ASM), which is also known as “Classic”. Now this has been replaced and is called the Azure resource manager (ARM) API. ARM is the deployment […]
2019-06-03
2,029 reads
Date and Time Conversions Using SQL Server
There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it.
2019-06-03
Introduction to SQL Server Security — Part 6
SQL Server has many tools used to make it secure. In this article, Robert Sheldon demonstrates several of these features including SQL Server Configuration Manager and the Vulnerability Assessment tool.
2019-06-03
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
BCA KCU WAHID HASYIM No.Telpon 087781685647
Whatsapp 087781685647 Jl. K.H. Wahid Hasyim No.183 A-B, RT.14/RW.6, Kb. Kacang, Kecamatan Tanah Abang,...
BCA KCU PONDOK INDAH No.Telpon 087781685647
Whatsapp 087781685647 Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec. Kebayoran Lama, Kota...
BCA KCU SUDIRMAN No.Telpon 087781685647
Whatsapp 087781685647 Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi, Kota Jakarta...
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers