SQL 2008 Auditing Presentation in NJ by the MAK!
If you are a regular to the sql server community sites, forums and blogs, then you know about the awesome stuff brought...
2010-03-15
1,035 reads
If you are a regular to the sql server community sites, forums and blogs, then you know about the awesome stuff brought...
2010-03-15
1,035 reads
Article on I/O tips appearing on SQLMag.com
If you've followed my blog, you know I've written on various topics, including I/O...
2010-02-26
1,938 reads
After a great presentation from Brian Knight at the NYC User Group, Robert Pearl summarizes some information about SSAS and when it makes sense to use this subsystem. And why you might want to attend that next user group meeting.
2010-02-19
10,363 reads
If you can't make #33 in NC, there's always #39 in NY -
SQLSaturday#39 in NYC!
It's shaping up to be another...
2010-02-17
637 reads
RedGate Releases SQLSearch - FREE!
SQL Search - Released
My friends at RedGate have released a new FREE Tool. Please read on to learn...
2010-02-02
792 reads
OK, you've seen many of these before, but if you haven't figured out its TIME to upgrade your SQL Servers to...
2010-01-21
1,206 reads
Recently, I was asked to do an extensive sql server performance audit and review. I will be sharing some of...
2010-01-15
9,537 reads
What do you do when you run an SSIS package and it works, but it fails when scheduled? You might have a credential problem. Robert Pearl brings us a solution to a cryptic message that prevents you from scheduling a package.
2009-12-10
9,850 reads
Today, on SQLServerCentral.com, SSIS Package Credentials, is the featured article on the site.
I originally drafted this article as a blog post, and...
2009-12-10
680 reads
As you know if you follow this blog, Pearl Knows is the creator of the monitoring software SQLCentric, and offers...
2009-12-07
580 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