Browse by Tags

• PowerShell

• listing all the Databases from a SQL Server from PowerShell

  I was reading this thread http://web2.minasi.com/forum/topic.asp?TOPIC_ID=25963 , that discusses retrieving a list of databases from SQL server and a query was used. There is also a Stored procedure available in SQL server to list all the databases, as... Posted Feb 28 2008, 09:11 AM by The PowerShell Guy Filed under: PowerShell, SQL Server

• MSDE a memory hog....

  MSDE a memory hog..... Who da thunk... not me .... Dear Susan Bradley, After extensive research and monitoring, it has been determined that the resource used by SQL express engine causes a dramatic performance decrease for the server. Futhermore, it creates... Posted Feb 19 2008, 10:12 PM by The Official Blog of the SBS "Diva" Filed under: SQL Server

• Per my read...

  http://support.microsoft.com/lifecycle/?LN=en-us&p1=2852&x=4&y=8 SQL 2000 falls out of mainstream support in April of 2008. If your line of business vendor is still only supporting SQL 2000, sit them down and have a talk with them. Ask them... Posted Jan 05 2008, 02:59 AM by The Official Blog of the SBS "Diva" Filed under: SQL Server

• Keepin' up with SQL

  The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released: http://support.microsoft.com/kb/937137/LN/ I have no idea what build number I have of SQL 2005 to be honest with you...but I'm losing track of 'em... Posted Dec 17 2007, 10:15 PM by E-Bitz - SBS MVP the Official Blog of the SBS "Diva" Filed under: SQL Server