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
617 reads
Last week I attended SQLRally Nordic 2015 in Copenhagen. SQLRally is a regional conference organized by PASS, kind of a...
2015-03-10
617 reads
I had the pleasure to speak at SQL Saturday 360 in Israel. It was such a great event! We had...
2015-01-28
600 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,366 reads
Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for...
2014-12-16
795 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,550 reads
This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan...
2014-11-27
7,144 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,032 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,576 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,870 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers