2022-04-06
7,887 reads
visual studio
Adding Custom Stored Procedure Templates to SQL Server Management Studio and Visual Studio 2019
In this article we look at how to build a custom stored procedure template that can be used in either SSMS or Visual Studio for all new development.
2020-10-29
Install SQL Server Integration Services in Visual Studio 2019
Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.
2020-07-31
Install SQL Server Integration Services in Visual Studio 2019
Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.
2020-07-16
SQL Server From .Net: Connecting Visual Studio Community Edition
This is a short description of how to connect the free Visual Studio Community Edition to the free SQL Server Express edititon.
2018-05-08
1,014 reads
Install Visual Studio 2015 in Server without Internet Connection
Install Visual Studio 2015 in Windows Server without Internet Connection
2018-01-15
7,872 reads
Creating a Robust SSIS Development Environment using the SSIS Catalog
Discover how to integrate features of Visual Studio and the SSIS Catalog for an efficient development and deployment environment.
2021-06-11 (first published: 2017-07-31)
15,603 reads
SQL Server Unit Testing in Visual Studio
Unit test stored procedures in Visual Studio using an existing database or new SQL scripts
2020-01-03 (first published: 2017-05-01)
16,073 reads
Redgate Data Tools in Visual Studio 2017 Enterprise
Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development.
2017-03-09
5,294 reads
Stairway to U-SQL Level 7: More Partition Schemes
Following on from our previous introduction to indexes and partition schemes, we review the distribution schemes used by horizontal partitioning.
2016-08-24
1,639 reads
Blogs
EightKB 2024 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
T-SQL Tuesday #176: That Piece of Technical Advice for the Past Me
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers