Using Synonyms in SQL Server 2005
It's nice to have little amenities in your development tools. They make for easier development and can save you a little time. Synonyms is one of those tools.
2007-01-03
3,795 reads
It's nice to have little amenities in your development tools. They make for easier development and can save you a little time. Synonyms is one of those tools.
2007-01-03
3,795 reads
Security has become more and more important in today's business environment. From the database point of view, DBAs and system administrators need an improved security model. SQL Server 2005 provides an improved security feature. It is claimed that SQL Server 2005 is secure by default. In SQL Server 2005, the security model is divided into three areas namely authentication, authorization, and encryption.
2006-12-29
2,741 reads
As a DBA, you can find very useful information in the Windows event logs. About important events, the health of your SQL Server and the operating system it runs on. Unfortunately, the logs also contain a lot of useless information. Some applications have a tendency to log hundreds of events every day, filling up the logs very quickly with info that you, as a DBA, do not need. But you still need to see that important message that informs you the server is going to crash if you don’t take action.
2006-12-28
2,298 reads
Because many programs I wrote depends on the SQL Agent Service and to really make sure that no one has configured this service to run manually (you see many things in life) I rely on this litle piece of code
2006-12-27 (first published: 2004-09-16)
180 reads
Utilizing design patterns with SQL Server 2005 Service Broker enables you to assess and select appropriate solutions for all of your SQL Server 2005 asynchronous messaging needs.
2006-12-27
2,224 reads
Procedure to help find missing constraints when comparing two databases that are supposed to be the same. SP has ability to show all constraints per database, and the ability to generate create scripts to make adding the missing constraints easier.
2006-12-26 (first published: 2002-03-12)
749 reads
In this article we will set the chart control on a report and populate it. We will also cover the different charting display options and I'll demonstrate some rather cool formatting techniques.
2006-12-26
2,718 reads
2006-12-25
2,934 reads
This short blog post looks at how you can use a stored procedure as a data source.
2006-12-22
2,284 reads
When designing and creating a data model for a data-driven application, the records in tables must each be uniquely identifiable. By having a unique value associated with each record, individual records can be selected, updated, or deleted. Being able to uniquely identify records is so important and standard in a database system that databases allow those designing a database table to specify what column (or columns) make up the primary key.
2006-12-22
3,518 reads
By Steve Jones
mcfeely – adj. inexplicably moved by predictable and well-worn sentiments, even if they are...
I posted on Terraform and Azure SQL last year but wanted to see what...
By Kevin3NF
As a SQL DBA, what do you do when a vendor application has performance...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
HI All, can any one reply on this when primary is down and not...
Comments posted to this topic are about the item The On-Call Load
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers