Virtual SQL Playground Adventure: Building The Virtual Environment
Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual...
2014-03-14 (first published: 2014-03-03)
3,641 reads
Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual...
2014-03-14 (first published: 2014-03-03)
3,641 reads
Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource...
2014-01-14 (first published: 2014-01-09)
3,142 reads
Packt Publishing has published SQL Server 2012 Reporting Services Blueprints – the book that Mickey Stuewe (b | t) and I have...
2013-10-29
1,292 reads
Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure?
An adventure is an exciting or unusual experience; it may...
2013-06-13
1,455 reads
The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to my physical...
2013-05-31 (first published: 2013-05-24)
4,482 reads
How many lines of TSQL codes and Window Functions you need to come up with this?
With R, it takes about...
2013-05-16
896 reads
This post is inspired by Andy Warren’s ( b | t ) “Books On The Desk” post.
I’ve got plenty of SQL Server books...
2013-05-10
911 reads
Joe Lacob bought the struggling Golden State Warriors NBA franchise in 2010. He has been the most hated man by...
2013-05-03
807 reads
I’ve been looking for better ways of learning and improving my SQL Server skills. Blogs, BOL, webcasts, and training videos...
2013-04-13
704 reads
There is something about the Silicon Valley that attracts the innovative and creative individuals. The “misfits, rebels, troublemakers, and the...
2013-02-20
923 reads
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers