(Muthusamy Anantha Kumar) This installment of the series illustrates how to use PowerShell scripts in conjunction with SMO and parameters to Generate an SQL Server Script. Generating SQL Server Scripts is an essential task for SQL Server Database administrators and developers.
Other News
Using a typeof() in Powershell for SMO server.SetDefaultInitFields
(Ben Miller) In trying to squeeze performance out of the SMO stuff that I have been learning and doing for SQL Server I came across the method on the Server object called SetDefaultInitFields. In my previous posts on Powershell or .NET and SMO, when you start scripting Views and Stored Procedures y
Skills Zone: Five Tips for Acing DB2 and other IBM Exams
(Howard Fosdick) No question about it, DB2 certification exams are challenging. Answering the questions correctly requires real thought. Answers are rarely obvious. Follow these test-taking tips (gleaned from discussions with dozens of IBM-certified DBAs) for an edge on any certification exam. (Alth
Headed to DevConnections/SQL Connections
Featured Article(s) Find all tables and schemas without a primary key constraint The following procedure generates a list of all tables in all schemas and in all server’s user databases that a PK constraint is NOT defined on them. Read: Integration Studio Review Friday we published a review of Relational Solutions BlueSky Integration Studio – if you’re building SSIS projects, […]
The Growing Popularity of MySQL: The friendly kid in the playground
(George J. Trujillo Jr.) I was sitting at dinner the other night with some MySQL DBAs that have worked with Oracle and SQL Server and we were talking about the differences between the different databases and the different paths to success. These impressions were just points of discussion over dinner
Are you ready for AJAX risks?
(Dave Johnson, Alexei White and Andre Charland) AJAX has at least three main areas of risk: technical, cultural/political, and marketing risks:
DB2 Express-C 9.5 is available for download
(Antonio Cangiano) IBM has just released the new version of DB2 Express-C, the free dataserver without any limits on database size or the number of users. It’s not been posted yet on the official page, but you can already download DB2 Express-C 9.5. Get the Linux version from here and the Windows ve
How to find the earliest start date and the latest end date for consecutive transactions in SQL
(Frank Zhou) The following two SQL patterns can be used to find the earliest start date and latest end date for consecutive transactions within a group in a SQL Statement.
Implementing a simple Silverlight Control
(Phil Curnow) I am sure that many of you have read about Silverlight, the latest offering from Microsoft promising the ability to deliver rich interactive applications and media. Silverlight 1.1 Alpha has just been released and with this in mind, I decided to download all the tools required to start
Some more String Functions
In some of our previous posts, we have covered different types of functions (String functions, mathematical functions, datetime functions etc.) that exist in Oracle, SQL Server and DB2 LUW. You can search for functions on our blog site and get to those posts. In this post, we will cover some other f