#mssqlserver

[gsoftcloud]

Is your MS SQL database vulnerable to cyberattacks? Don't let criminals steal your valuable data! Check out the best practices from #gsoftcloud experts for fortifying your database & data management using MS SQL Server. Read now and learn how to outsmart cybercriminals!

Best Practices for Secure Data Management Using MS SQL Databases

Uncover the major cybersecurity threats that MS SQL database management systems face and follow the best practices outlined in this blog to

[syntlex-blog1]

#aspnet #asp #core #backend #mssqlserver #syntlex (at Buenos Aires, Argentina) https://www.instagram.com/p/B903eHGHOib/?igshid=ax0l7wppv5mn

[syntlex-blog1]

#mssqlserver #nodejs #MVC #microsoft #mssql #syntlex for Big Data (at New York City, N.Y.) https://www.instagram.com/p/B9ixTiUH-8U/?igshid=552pbm6sci5j

[anuradha-us]

Diwali bumper discount on #SqlServerCourse. You will get 30% Discount. Offer valid till 27th October. Don’t just learn it, master it. Book your free demo. Hurry-up

[techskills-blog1]

SQL Performance Tuning - Extended Events in SQL Server

This article discusses how we can use extended events for performance tuning of SQL Server. http://bit.ly/2x2JKYS

[cabbagepost]

SQL Server Notes

Copy data from one db to another

SELECT * into targetDB.dbo.TargetTableName FROM sourceDB.dbo.SourceTableName

[shirivo]

Filtrando SPs según palabras clave

Filtrando SPs según palabras clave

Escenario. En un proyecto se tienen más de 100 stored procedures (SPs). El cliente solicita un cambio en el nombre de los SPs que utilicen una tabla en específico.

Solución. Este query en TSQL nos permite filtrar los SPs que tengan un texto en específico.

SELECT *

FROM

SYS.PROCEDURES P

JOIN SYS.SYSCOMMENTS C ON P.OBJECT_ID = C.ID

WHERE

TEXT LIKE ‘%TEXTO%’

Ejemplo. Se necesita encontrar los SPs…

View On WordPress