Blog Archives

How to configure SQL Database mail (or any other application) to send emails using Office 365 (Exchange Online): A walk through and options

  Hi, What I have come to understand is that with Office365 email routing the configuration settings for email relay are, Server:                                 smtp.office365.com Port Number:    587 Authentication:                Basic (An email address and password) We can set this up

Tagged with: ,
Posted in email, SQL Server, Uncategorized

SQL Tip: Read + Write (or any) role on databases, all existing and new ones

Trying to avoid the double hop issue which configuring linked servers, I opted for local users. After setting them up I asked the developer who requested this as to which databases he wanted to be read across the servers /

Tagged with:
Posted in SQL Server, tsql, Uncategorized

SQL Tip: How to find SQL Server installation date and time

Getting right down to business… heres the script SELECT create_date FROM sys.server_principals WHERE sid = 0x010100000000000512000000 And for Eval versions — Evaluation Version Expire Date SELECTcreate_date ASInstallationDate, DATEADD(DD, 180, create_date) AS’Expiry Date’ FROMsys.server_principals WHEREsid = 0x010100000000000512000000 GO Reference: Pinal Dave (http://blog.sqlauthority.com)

Tagged with:
Posted in sql, SQL Server, tsql, Uncategorized

SQL Server 2016 SP1 – The game changing release… seriously

SQL Server 2016 SP1, In short with this release Microsoft has enabled many features in Standard, Web and even Express editions which were only previously available in Enterprise.

Tagged with:
Posted in Uncategorized

Datawarehouse Database Cleanup SQL query

Originally posted on Scompanion:
IMPORTANT: Always perform a FULL Backup of the database before doing anything to it !!! This article applies to SCOM 2007 and SCOM 2012 Somtimes you may have event storms where you end up having old…

Posted in Uncategorized

SQL 2005 – 2016, Migrated CLR objects / Assemblies causing access error messages

You may receive an error message when you try to run an existing CLR object or create an assembly that has the external_access or unsafe permission set on a database that is attached or restored from a different server

Tagged with:
Posted in SQL Server, Uncategorized

SQL Server 2016 new features & common performance issue of Tempdb Contention

Tempdb the “shared resource” or the “scratch pad” or even the “waste bin” as described by many names in SQL Server has of course a lot many important things to do but by very nature of any shared resource there

Tagged with: , ,
Posted in log, sql, SQL Server, Uncategorized

UBEREATS is offerring free lunch to Londoners using voucher codes eats-zeeshanz262ue

Hungry? Get £10 off your first order on #UberEATS with my code: eats-zeeshanz262ue. http://ubr.to/EatsGiveGet Better yet, install the app. Kind regards, Syed Zaidi

Posted in Uncategorized

Windows 10 Free upgrade, ended or still available ?

You bought a PC / laptop after the day Windows 10 free upgrade is over or just decided you would like to upgrade your Windows 7+ machine ? And Microsoft is charging around £100 and upwards depending on the version you

Tagged with: , ,
Posted in Uncategorized, windows, windows 10, windows 10 free upgrade

Duration (HH:MM) calculation between two time stamps

Datediff function or variations of it work fine generally but… if you want to have exact duration in Hours:Minutes or HH:MM format. You gotta do what you gotta do one of which is as follows. This basically rounds off the

Tagged with: , , ,
Posted in tsql, Uncategorized, vbscript