SQL Server - Oracle Architectural comparison
This is one of the session I took for SQL DBA to understand the basics of Oracle, Its a powerpoint presentation but...
2012-08-06
4,566 reads
Auto Shrink of all T-Log File on a SQL Instance - TSQL
This Script will shrink all the T-Log files of SQL instance if there is no active tracsaction on the database. The...
2012-08-02
2,646 reads
Replace NOT IN with JOIN
Example of how to replace NOT IN clause with JOIN
/*NOT IN query*/
USEAdventureWorks;GOSELECTProductIDFROMProduction.ProductWHEREProductIDNOTIN(SELECTProductIDFROMProduction.WorkOrder);
/*JOIN Query*/:-
SELECTp.ProductIDFROMProduction.ProductpLEFTJOINProduction.WorkOrderwONp.ProductID=w.ProductIDWHEREw.ProductIDISNULL;
2012-08-02
4,718 reads
SQL database Incremental Shrink TSQL
When we shrink a SQL database through GUI we usually find the database never releases all the free space, It...
2012-08-02
12,548 reads
SQL security scripting - TSQL
SQL DBA often needs to script SQL Logins,Server roles,database users and Roles. Although its easy to script login,roles and users with...
2012-08-02
1,281 reads
Set Up SQL Server Mirroring T-SQL Script
T-SQL Script to create a SQL Mirroring:-
The first thing you need to do when setting up Database Mirroring is perform...
2012-08-01
20,320 reads
Blogs
Github Copilot in SSMS can include data in its memory, simple prompt injections ahead
By Ed Elliott
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Forums
A Place where AI Technology Shines
Comments posted to this topic are about the item A Place where AI Technology...
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers