SQLRally Nordic 2015
Last week I attended SQLRally Nordic 2015 in Copenhagen. SQLRally is a regional conference organized by PASS, kind of a...
2015-03-10
616 reads
Last week I attended SQLRally Nordic 2015 in Copenhagen. SQLRally is a regional conference organized by PASS, kind of a...
2015-03-10
616 reads
I had the pleasure to speak at SQL Saturday 360 in Israel. It was such a great event! We had...
2015-01-28
599 reads
I have been working with SQL Server for the past 17 years, and in the past few years I have...
2015-01-12
633 reads
This is a summary of the parameterization blog post series. If you read the previous posts in the series, then...
2015-01-12 (first published: 2015-01-08)
7,362 reads
Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for...
2014-12-16
792 reads
Sometimes you have a stored procedure that returns a rowset, and you need to insert the rowset into a temporary...
2014-12-04
1,545 reads
This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan...
2014-11-27
6,844 reads
I presented my session – Working with Very Large Tables Like a Pro in SQL Server 2014 – in PASS Summit 2014....
2014-11-08
1,031 reads
Here is a riddle for you…
You are requested to move a database from an old server to a new server....
2014-10-24 (first published: 2014-10-20)
7,567 reads
This is the fifth post in my Parameterization series. In previous posts I wrote about parameter sniffing and when it is...
2014-09-23 (first published: 2014-09-20)
8,853 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
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...
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
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers