Contents tagged with sql
-
Prevent Object Create in Master Database in SQL Server
USE masterGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TRIGGER DDL_PreventObjectCreationInMasterDBON DATABASEFOR CREATE_TABLE, CREATE_VIEW, CREATE_PROCEDURE,CREATE_FUNCTIONASBEGIN-- SET … more
-
Generate SQL MERGE statements with Table data
https://github.com/readyroll/generate-sql-merge more
-
Convert EF Entity Framework or Linq to SQL
-------------------------------------------
Using code in Visual Studio
-------------------------------------------
.ToString();
.ToTraceString();
dc.GetCommand(query).CommandText
p. … more
-
What is LINQ When Querying Data in C#
https://en.wikipedia.org/wiki/Language_Integrated_Query#LINQ_to_SQL_.28formerly_called_DLINQ.29 more
-
SQL Server Memory Consumption by Object
https://www.sqlserverscience.com/performance/memory-consumption-by-object/ more
-
SQL: How an OR Short Circuits
https://sqlstudies.com/2019/06/17/its-interesting-how-an-or-short-circuits/ more
-
SQL and NULL Mistakes
https://www.red-gate.com/hub/product-learning/sql-prompt/the-null-mistake-and-other-sql-null-heresies more
-
SQL Mistakes
https://www.sqlservercentral.com/articles/some-of-my-greatest-mistakes more
-
Free SQL Azure Database
There used to be a free tier for SQL Azure Database, as well as a free web app tier. But now the free SQL Azure Database tier seems to have disappeared.
https://renouncedthoughts.wordpress.com/201 … more
-
12 Ways To Rewrite SQL Queries for Better Performance
https://www.sqlservercentral.com/blogs/12-ways-to-rewrite-sql-queries-for-better-performance more
-
Connect Python to SQL
https://datascienceplus.com/connect-python-to-sql/ more
-
SQL to DAX Conversion
SELECT TOP(1) InventTrans.CustVendAC
FROM InventTrans
WHERE InventTrans.DataAreaId = 'DAT'
AND InventTrans.StatusReceipt = 1
… more
-
Interpreting Spotfire Logging to Understand User Activity
https://datashoptalk.com/spotfire-logging-user-actions/
https://community.tibco.com/questions/does-spotfire-keep-log-files-sql-queries-it-runs
https://community.tibco.com/wiki/analyze-tibco- … more
-
SQL Data CAT (Customer Advisory Team) and Performance
https://techcommunity.microsoft.com/t5/DataCAT/bg-p/DataCAT
http://www.sql-server-performance.com/ more
-
How Do You Export A Database In Azure Data Studio
https://www.scarydba.com/2019/02/25/export-a-database-in-azure-data-studio/ more
-
Linked Server to SQL Azure
https://www.sqlshack.com/create-linked-server-azure-sql-database/
https://stackoverflow.com/questions/28590832/i-need-to-add-a-linked-server-to-a-ms-azure-sql-server
https://stackoverflow.com/ … more
-
Testing Credit Card Numbers with Luhn Algorithm in SQL
https://www.red-gate.com/hub/product-learning/data-masker/spoofing-realistic-credit-card-data-test-systems-using-data-masker
https://www.red-gate.com/simple-talk/blogs/the-luhn-algorithm-in-sql/
-
Visual Representation of SQL Joins
https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
-
SQL: Merge Statement
https://stackoverflow.com/questions/14806768/sql-merge-statement-to-update-data more
-
SQL: Using NOT IN Operator with NULL Values
http://www.sqlbadpractices.com/using-not-in-operator-with-null-values/