Category: SqlServer
-
SqlExtensionsAspire–part 2–code
I wanted the code to be easy used by any programmer that uses SqlServer in ASPIRE , such as For this to work, I create extensions – you can see them at https://github.com/ignatandrei/aspireExtensions/blob/main/src/SqlServerExtensions/SqlExtensionsAspire/SqlServerExtensions.cs Some problems that I solved 1. Versioning The Aspire version was 9.3 , so my version of the nuget SqlExtensionsAspire is 93.2025.208.1818…
-
SqlExtensionsAspire–part 1–idea
Aspire is a popular orchestrator for managing projects and Docker containers in the .NET ecosystem. While it’s primarily known for .NET, Aspire also supports other technologies like Node.js, Python, and more. Since I use SQL Server as my database, I found myself needing a few essential features: Execute pre-defined SQL commands at database creation timeI…
-
TILT- tables–part 4
I will keep very simple the database schema. I do not want for the moment an users table,so I just create a table with url a table with the tags a table with notes Azure Data Studio Trying Azure Data Studio – good point that it is integrated with Azure. Bad point – finding it…
-
Use the right language for the job–if you know
Many years ago I have done a site that lists the exchange rates from BNR and BCE ( www.infovalutar.ro ). It reads the exchanges from BNR html page and then put into a database. The use is for programmers – there are many methods to find latest exchange rates ( RSS,SOAP,url,by MVC,JSON… – see all…
-
Import large Excel file into SqlServer
I have to import the list of NGO from Romania to SqlServer. Before seeing my solution,please do it yourself: the file could be found at http://www.just.ro/registrul-national-ong/ and the name is Asociatii I have tried with SSMS – no luck ( text will be truncated,even when I put nvarchar(max)) The I tried with flat file from…
-
Maintaining history of data
What is this about? I tend to quote Fowler: “Usually when we see properties on a class,they represent questions we can ask of an object now. However there are times when we don’t want to just ask questions about a property of an object now,we also want to ask these questions about some point…
-
Monitor SqlServer Stored Proc execution time
I have had the task to made something to monitor what stored procedure,in Sql Server,in most used. The problem that I have had is that the host_name is easily changed by putting,in the connection string WSID (see http://msdn.microsoft.com/en-us/library/ms178598.aspx ) The code is for sql server 2005 and I have not realized without the help of…
-
Sql Server Management Studio free awesome addons
The two addons that I can not live without in Sql Server and that,more,are free : SSMS Tools Pack – now 1.7.5.1,http://www.ssmstoolspack.com/Download SQL Search – now1.0 http://www.red-gate.com/products/SQL_Search/ The SSMS Tools Pack maintains a history of your commands . More,it saves on the C:\SSMSTools\SQLQueryActionLog The Sql Search finds a text in the objects in…