Creating Your Dream Project
In this article, columnist Christopher Duncan shows you how to create your dream development project.
2002-11-15
5,702 reads
In this article, columnist Christopher Duncan shows you how to create your dream development project.
2002-11-15
5,702 reads
In this article, James Travis covers a common performance topic of prefixing stored procedures sp_. Does it really slow down performance?
2002-11-14
7,054 reads
Recently, the SQLServerCentral.com labs had the chance to get a sneak peak at Lumigents latest creation, Entegra, which is scheduled to ship in the second week in December. Entegra monitors database activity and provides a complete record of access to the data and changes to database structure and permissions.
2002-11-13
3,302 reads
How often do you move your master database? Hopefully never, but this article looks at an easy technique should you need to perform this trick.
2002-11-12
10,007 reads
We're curious to see what our readers have to say about this one! How many of us have tables accruing data that won't be used and/or isn't of any value? At what point do we get rid of it to free up resources?
2002-11-11
9,219 reads
Are you tired of manually restoring each database on a new server when the original server has a melt down? Does the manual process seem slow, and prone to keystoke and mouse click errors? Would you like to have those restore scripts automatically built, so you only have to fire them off? Well this article will show you one possible method for speeding up and reducing errors will trying to perform a restore of all databases on a server.
2002-11-05
9,009 reads
You're behind a firewall, you have passwords. Why spend any great amount of time on extra database security? Steve thinks there are a few reasons why in this article.
2002-11-04
4,477 reads
Microsoft has released the "Books Online" equivalent for Notification Services. Browse through and take a look to see if this service is useful to you.
2002-11-01
694 reads
Andy Jones recently faced a requirement to load several flat files on a nightly basis. In this article, Andy Jones shows you how he accomplished this and shows plenty of code!
2002-10-31
11,212 reads
Microsoft has formally clarified the support life cycles for it's products. See where your products fall in and be sure to plan for upgrades.
2002-10-30
3,333 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
There is a table tblItems with below structure ( i cannot change the below...
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers