SQL Server Operations Studio and VSCode: The wrong default datetimeoffset format
This post is to answer the question: “You are used to seeing in the format of yyyy-MM-dd right?” that I...
2018-09-12
407 reads
This post is to answer the question: “You are used to seeing in the format of yyyy-MM-dd right?” that I...
2018-09-12
407 reads
This month’s T-SQL Tuesday is brought by Steve Jones (b | t) and he wants to know if triggers causes headaches or happiness to us.
This is the 106nd edition...
2018-09-11
This month’s T-SQL Tuesday is brought by Steve Jones (b | t) and he wants to know if triggers causes headaches...
2018-09-11
234 reads
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will...
2018-09-05
255 reads
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will be speaking about dbachecks PowerShell module - dbachecks -...
2018-09-05
1 reads
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will be speaking about dbachecks PowerShell module - dbachecks -...
2018-09-05
Almost all the applications we use have a lot of options. And, sometimes we even stumble across them by accident.
Who’s...
2018-09-04
251 reads
Almost all the applications we use have a lot of options. And, sometimes we even stumble across them by accident. Who’s ever heard something like “Normal user don’t even...
2018-09-04
I’m working on a project where I need to convert Firebird SQL code into T-SQL code.
No schema, just the modules....
2018-08-24
294 reads
Starting on 19th of July and during 3 days the Tuga IT 2018 Summer Edition will be happening in Lisbon!
This...
2018-07-06
307 reads
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
By Steve Jones
mcfeely – adj. inexplicably moved by predictable and well-worn sentiments, even if they are...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
HI All, can any one reply on this when primary is down and not...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers