This stored procedure gives you metadata information from the reportserver database about published reports, datasources, directories,authorized users/groups,(shared)schedules and subscriptions.I integrated this stored procedure in a report in our MS report services environment for auditing purposes
2006-07-14 (first published: 2005-06-01)
442 reads
Kurt Windisch, Vice President of the Professional Association for SQL Server, recently returned from their European Conference. He shares a few notes on the event which was held earlier this month in Germany.
2005-05-31
2,878 reads
A simple User Function which will guarantee always to return a value from a division without any errorsExample : GPDivNErr(@Val1 float, @Val2 float)
2005-06-10 (first published: 2005-05-29)
461 reads
This is a User Defined Function that returns a 1 if date is a holiday else, it returns a 0.The holidays are:New years Day, MLK Day, Presidents Day, Memorial Day, Independance Day, Labor Day, Columbus Day, Veterans Day, Christmas Eve and Christmas Day
2005-06-13 (first published: 2005-05-27)
285 reads
If you are a developer creating Web services, a webmaster creating database-enabled pages or a database administrator (DBA) tuning SQL queries for a 24x7 web site, you've probably experienced the phenomenon known as "web time." The computer industry has never been quiet, but recent years have been particularly frenetic. The popularity of the web produced a flurry of software-development activity. New versions, new technologies, and new products appeared seemingly overnight. Web time became a useful phrase for describing compressed development cycles between new product releases and documentation that is obsolete before it arrives from the printer.
2005-05-25
2,125 reads
procedure will create xls spreassheet file based on the query passed and put it into the designated folder
2005-06-21 (first published: 2005-05-24)
1,009 reads
Knowing where you stand as a SQL Server 2000 DBA in terms of salary can be great information for your next review or raise discussion. Steve Jones participated in Information Week's 2005 survey and got the results back. Here are a few notes and thoughts from the survey.
2005-05-24
17,216 reads
A Chief Financial Officer (CFO) was approached by the CEO and asked for an accounting of the company’s financial assets. The CFO gave a vague response indicating a lack of knowledge of the corporate bank accounts, had little idea what was in each account, and had no idea about the status of accounts receivable. The Board of Directors asked the CEO about the intended use of the corporate assets and were told “there is no plan for their use.” The CFO and the CEO were soon pursuing new personal interests.
2005-05-23
2,209 reads
We've all been there: the project that never ends and no light at the end of the tunnel. Nothing is more disheartening to a developer, DBA or anyone else that may be on a project than a finish line that has no end in sight or worse yet, one that keeps moving. Agile and Scrum development methodologies aim to fix this problem and others by applying what will appear to be common sense after you engage in the methodology for a few projects. This article will get you acquainted with my now-favorite d
2005-05-18
17,058 reads
SQL Server 2000 is an extremely powerful and flexible development platform, but if the users mess up the data, there's nothing you can do. Protecting the integrity sometimes means severely limiting access to users. Roy Carlson brings us a technique using sp_makewebtask that you can easily use to provide users with some data without giving them query access.
2005-05-17
15,064 reads
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Setting page visibility and the active page are often overlooked last steps when publishing...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers