1000 Views on 26 Blog Posts – Thanks a Ton
Thank You all for your support to give me inspiration . It is the result of this that I have achieved...
2013-01-09
447 reads
The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.
Reblogged from MSSQLFUN:
Issue : Today I have read one issue over one forum, One user is having below 3 DB roles...
2013-01-09
5,457 reads
The EXECUTE permission was denied on the object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’.
Issue : Today I have read one issue over one forum, One user is having below 3 DB roles on MSDB...
2013-01-09
10,730 reads
What port is my instance listening on?
I just had the interesting task of finding the port number that one of the instances I deal with is...
2013-01-08
1,712 reads
Partitioning Relational Data – (Part – 1)
A common requirement for dealing with large datasets is the ability to split the data into smaller blocks to help...
2013-01-08
1,023 reads
XML schema (XSD)
When creating XML documents, you must work from a design that defines the structure of the document. This strengthens the...
2013-01-08
1,002 reads
SQL Saturday Fargo Update
It’s been a while since I mentioned anything about the SQL Saturday in Fargo. So I thought I would let...
2013-01-08
581 reads
SQLAgent Job related reports and out of box real time job monitoring tool !
Lets start New Year with a very simple yet useful topic.
I am a big fan of out of box reporting...
2013-01-08
1,266 reads
Index Analysis Update – January 2012
In the past couple weeks, I’ve gotten a couple reports of issues with sp_indexanalysis. The update today fixes those issues....
2013-01-08
756 reads
Master Data Management (MDM) Hub Architecture
The Master Data Management (MDM) hub is a database with the software to manage the master data that is stored in...
2013-01-08
8,839 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers