SQL Server Integration Services (SSIS) is a fast and reliable way of importing and exporting data, but it can be tricky to learn, initially. Rob Sheldon provides a beginner's guide to get you started with using SSIS with Visual Studio and SQL Server Data Tools (SSDT).
The potential vulnerabilities of wireless devices might be a security issue for databases.
Find out how to speed up your queries by indexing and partitioning data, U-SQL style.
Tim Radney of SQLskills shows how the Stretch Database feature has evolved from its early CTP beginnings to the RTM version released earlier this month.
When do you have too much data? What do you do if you aren't actually using all of it?
A brief overview of how to reclaim storage space after altering the data type of a column.
In this tip Jugal Shah looks at the steps within SQL Server you need to follow if you change the physical server name for a standalone SQL Server.
Everybody says that the backup process in Azure SQL is very easy. Is that true? In this new article, we will show how to do it.
The complexity of tables makes modifying them over time a challenge, especially as data sizes grow.
This week Steve Jones looks at a new idea, rating the security of products publicly to try and shame vendors into more secure coding.
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers