Despite the attention to data privacy and protection caused this year because of the GDPR, regulations governing how data is handled are nothing new. In this article, Robert Sheldon provides an overview of two US regulations, HIPAA and SOX, and explains how these regulations affect DBAs.
An SSIS package that is executed on an ad hoc basis can be run from Business Intelligence Development Studio easily enough, but a package that is going to be run on a regular schedule is best executed through a batch file using the DTExec.exe command line utility.
Brent shows you how the table joins work and points out some neat data distribution issues.
When we risk failure, we also have the opportunity for success, so try something new today.
PowerShell is the preferred scripting tool used by Windows and Active Directory administrators. It can also be used to administer SQL Server or even just export data. In this article, Greg Moore demonstrates how to use the PowerShell cmdlet Invoke-SQLCMD to export data from SQL Server.
Learn how to create a SQL Server database in Azure in this level.
The ways in which we collect and use data aren't always apparent to our customers. Perhaps we should do better.
Error converting data type varchar to numeric may occur when trying to import data that looks like numbers, but doesn't act like a number. Read how to solve this issue.
We can't protect against all hacks, but can we prove they weren't our fault?
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
I’m doing a small series on indexing basics for SQL Server, and on May...
Kawasan Terpadu Pusat Kota, Gedung Perkantoran Tower One, Lantai Dasar, Jl. KH Mas Mansyur...
Jl. H. R. Rasuna Said No.Kav. 01, Guntur, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah...
Wisma GKBI, Jl. Jend. Sudirman No.28 14, RT.14/RW.1, Tikungan. Hilir, Kecamatan Tanah Abang, Kota...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers