Today, I worked on automating the process of importing a structured .csv file into a table using SQL Server Management Studio (SSMS). Since I am working with a desktop-based SQL Server database, the ...

--Essa rotina é opcional. Caso não queira ligar um profile no servidor, não execute esses script. Você também pode usar um Extended EVENT se preferir. --This script is optional. If you don't want to ...

Use custom-built .NET Framework 4.0 classes to connect an ASP.NET Web application to a SQL Server 2012 database. In my recent article, I showed how to connect .NET 4.0 C# and Visual Basic applications ...

#SQLServer Script for archiving data in small batches If you are planning to Archive large tables in SQL Server, Don't just use one massive DELETE because you may end up filling up your logs and if ...