sp_depends have been one of the most used system stored procedures in SQL Server. In fact, many of us still use that even though Microsoft had annouced that it will be removed from the future releases.
Issues after Upgrade to SQL Server 2017 – Cannot Bulk Load Data Into the Table with Primary Key Constraint on it
Recently, we upgraded one of our Production Systems from SQL 2012 Enterprise to SQL 2017 Enterprise with CU8. The Upgrade process went smoothly without any issues. During the testing process, one such SQL Statement which was fetching the Data from Oracle Linked Server and inserting the same into a table hosted on SQL failed with the below error message:
Dynamic creation of an SQL table by using an XML file, and importing data from an XML file to an SQL table.
Third article in a series of three regarding NServiceBus, WebAPI and Azure Service Fabric
Simple utility for creating backups of SQL Server databases on a schedule
Why should we care about containers for development
A short tutorial on how to get started with creating SSMS extensions
In this post, we will get an overview and generate a basic label code using our database table column that will help in development.
Using Powershell and Windows Task Scheduler API to detect malicious login attempts on a remotely accessible SQL Server database
How to easily unpivot pivot data in SQL Server
A flexible way to generate unique numbers for things like invoice numbers
In this article, we are going to learn how to create a simple API in Node.js and using MS SQL as a data source on which we are going to perform CRUD operation.
Why you would use Common Table Expressions
Deploy Reports rdl files to SSRS using C# script
Prevent brute-force login attacks on a remotely accessible SQL Server database using T-SQL
More configurations and auditing tools
Additional logging and data collection
Weekly HTML5 event calendar with CSS themes, drag and drop support, date navigator. PHP/AJAX and ASP.NET MVC backends.
Create and run jobs kinda like SQL Server Enterprise – Users Guide
Solving the "Store update, insert, or delete statement affected an unexpected number of rows (0)" response.
A complete event calendar, using trucking/shipping as an example, built with Visual Studio Community 2015, C# MVC and jQuery.Fullcalendar
Snapshot Isolation Level in SQL Server
This article describes how to enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems. This is done by enabling snapshot isolation.
ADO.NET Micro-ORM to SQL Server
User defined procedure for make an HTML table from T-SQL Select statment
ETL Testing and data-validation, dynamic SQL rule generator
If you wanted to ramp up database DevOps, which development tasks would be most important for you?
In this article, you are going to learn about P2P Network and Windows Communication Foundation to share your files between peers through a P2P network.