tag:blogger.com,1999:blog-137529932024-03-04T22:14:55.493-06:00Modern Data InsightInsight into modern data analysis and business intelligence.Unknownnoreply@blogger.comBlogger38125tag:blogger.com,1999:blog-13752993.post-79997751833708143302007-09-16T13:42:00.000-05:002017-05-11T20:25:15.936-05:00SQL 2008
SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights. moreUnknownnoreply@blogger.com3tag:blogger.com,1999:blog-13752993.post-47914564579653012007-03-17T20:43:00.000-05:002008-08-27T19:55:32.973-05:00Microsoft a BI ForceMicrosoft BI is a new tool. It is delivered through three layers or workloads: data warehousing, reporting and analysis, and performance management. These are designed to provide a consolidated, comprehensive data source and tools to help improve decision making. Microsoft BI is to help decision makers at all levels.An IDC report issued this summer—found that Microsoft’s BI market share growth Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-13752993.post-1139772983220197732006-01-12T13:28:00.000-06:002007-03-16T22:01:55.243-05:00ARRAY In SQL Server 2000On a number of occasions that I have regretted the fact that there is no such thing as Array in Microsoft SQL Server's Transact-SQL. Lots of other SQL programmers would mention the same thing. The array is one of the most common and highly used programming structures. Indeed, T-SQL does not provide for the fully functional array structure. However, SQL 2000 introduced the new feature called a Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-13752993.post-1137982147879658812005-12-16T20:03:00.000-06:002007-03-16T22:02:22.236-05:00Data Import Functionality Using SQL ServerDTS (Data Transformation Services) in SQL Server is very powerful feature and can be used to solve many database related issues starting from data migration, conversion and import/export. Even content publication/management applications can be developed easily using DTS. SQL Server’s DTS support is extended with latest version of SQL Server 2000. This article’s main goal is not only to Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1131338291290514882005-11-06T22:36:00.000-06:002007-03-16T22:02:39.910-05:00Embeded DatabaseVistaDB 2.1 database for .NET has been released This 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio 2005. VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build .NET 1.1 and .NET 2.0 applications. Features SQL-92 support, small 500KBUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1130266470574029842005-10-25T13:44:00.000-05:002007-03-16T22:06:41.492-05:00Parsing CSV Values Into Multiple RowsThis article explains how to take a string of comma-separated values(CSV), and parse out the values individually. If you have a table witha column of CSV values, and you want to translate them into a normalizedtable, it can really difficult. You would need to use a cursor to loopthrough your CSV table and process each row. Fortunately there's away to do this using just a regular SELECT. It Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1126810241862527222005-09-15T13:49:00.000-05:002007-03-16T22:11:21.774-05:00Understanding DBCC SHOWCONTIGDBCC SHOWCONTIG is a wonderful tool which helps you to understandquite a bit more about your system than is obvious at first glance. And,frankly, the documentation doesn't use terminology that makes it veryobvious either. So, this article will focus on a few of the big ideas behindthe tool using SQL Server, and how you can use it to better understandwhat is going on inside your SQL Server box. Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1126298722703976532005-09-09T15:44:00.000-05:002005-09-09T15:45:22.720-05:00Deleting Duplicate RecordsFollowing steps used to delete duplicate records1. Identify duplicatesselect au_lname, au_fname, city, state, count(*)from dup_authorsgroup by au_lname, au_fname, city, statehaving count(*) > 1order by count(*) desc, au_lname, au_fname2. Temp Table and Truncateselect distinct *into #holdingfrom dup_authors3. Rename and Copy Backsp_rename 'dup_authors', 'temp_dup_authors'4. Create a Primary Key (Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1126239304110275622005-09-08T23:13:00.000-05:002005-09-08T23:17:03.750-05:00SQL Server CESQL Server CE is available as a download for use with SQL Server2000 from the Microsoft Web site and as part of Microsoft''seMbedded Visual Tools 3.0. If you don''t have SQL Server 2000 andjust want to take SQL Server CE out for a spin, use the eMbeddedVisual Tools version. Both come with the Windows CE version ofQuery Analyzer, which provides a way to create and administerdatabases on the Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1125378266572542332005-08-30T00:02:00.000-05:002005-09-08T23:18:10.316-05:00SQL Server Web Data AdministratorThe SQL Server Web Data Administrator enables you to easilymanage your SQL Server data, wherever you are. Using its built-infeatures, you can do the following from Microsoft Internet Exploreror your favorite Web browser:- Create and edit databases in SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine- Perform ad-hoc queries against databases and save them to your file system- Export and Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-13752993.post-1125283009209546842005-08-28T21:35:00.000-05:002005-09-08T23:20:22.213-05:00SQL Server 2005 featuresFollowing 10 things you should know about SQL Server 2005 features :1. There is now an XML data type2. Distributed Management Objects (DMO) becomes SQL Server Management Objects (SMO)3. Common Table Expresssions recursive queries4. The Service Broker makes SQL Server traffic asynchronous5. Create .NET triggers6. SQL Server 2005 configuration is dynamic7. Define your own data types8. Many active Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1124737177771797842005-08-22T13:58:00.000-05:002005-09-08T23:20:41.513-05:00SQL BuddyThis is a C# Open source version of SQL Query Analyzer with code completion - If you type in a table name and hit ctrl-space, it has a dropdown with the columns, etc. I need a version that works from usb drive. Source SQL Buddy.Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-13752993.post-1124683418920509302005-08-21T23:02:00.000-05:002005-09-08T23:21:47.383-05:00Excel 2003 Formulas in SQL ServerThis article describes how to programmatically extract and store Excel formulas in a SQL Server database and replicate the UI-side calculations using dynamic SQL. In Part 1 of this article series shows how to take advantage of XML maps in Excel to create a template for data entry. Stored procedures are then used to perform aggregations for parent locations and update calculated data as well. You Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1124388610441872172005-08-18T13:08:00.000-05:002005-08-30T00:17:09.363-05:00Monitor SQL Server blockingThis article reviews how locking plays a role in SQL Server and how locking can lead to potential blocking problems. It looks at the typical methods currently in use to identify blocking as well as their advantages and disadvantages. Also introduces the Sherlock tool and its uses in quickly and graphically identifying blocking. Article by Roberto Alexis Farah (msdn), moreUnknownnoreply@blogger.comtag:blogger.com,1999:blog-13752993.post-1124291297146608442005-08-17T10:06:00.000-05:002005-08-30T00:17:47.036-05:00Controlling Transactions and LocksLocks are the mechanism databases use to control problems that may arise from simultaneous multi-user access. Some common issues locks try to manage include; what happens when two users try to change the same piece of information at the same time - who wins? Or user one tries to read data while user two is making changes on the same information, - which version of the data should user one see, Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1124221617372375582005-08-16T14:45:00.000-05:002005-08-16T14:48:03.623-05:00Stored Procedure - Error HandlingWhen an error is encountered within a stored procedure, the best you can do (assuming its a non-fatal error) is halt the sequential processing of the code and either branch to another code segment in the procedure or return processing to the calling application. Notice that the previous sentence is specific to non-fatal errors. There are two type of errors in SQL Server: fatal and non-fatal. Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1124125701412171512005-08-15T12:06:00.000-05:002005-08-15T12:08:21.420-05:00Different SQL implementationsSQL is implemented in different architecture. Different DBMS products handle various SQL (and related) features differenlty. The goal of this article — is to gather information relevant for people who are porting SQL from one product to another and/or are interested in possibilities and limits of 'cross-product' SQL. Article by Troels Arvin, moreUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1123880883043259942005-08-12T16:05:00.000-05:002005-08-12T16:08:03.050-05:00SQL StorySQL is the most popular computer language used to create, modify and retrieve data from relational database management systems. The language has evolved beyond its original purpose to support object-relational database management systems. The most frequently used operation in transactional databases is the data retrieval operation. Technically, SQL is a declarative computer language for use with Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1123772458437600372005-08-11T09:59:00.000-05:002005-08-11T13:21:39.880-05:00SQL MonitorIdera's SQLcheck quickly investigates, organizes and explains critical diagnostic information about your server's hardware, operating system and SQL Server. With SQLcheck's performance dashboard, you can quickly view detailed explanations and receive recovery suggestions. Get the information you need to efficiently manage your SQL Server environment. Make sure you have admin rights to the sql boxUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1123709098504085052005-08-10T16:23:00.000-05:002005-08-10T16:24:58.513-05:00SQL Server ClusteringSQL Server 2000 clustering can add much needed reliability and fault-tolerance to a production SQL Server 2000 system. But as you might imagine, its installation and configuration is not as easy an installing SQL Server 2000 on a single server.The purpose of this article is to show you how to install SQL Server 2000 Enterprise Edition onto a Windows 2000, two-node cluster using an Active/Passive Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1123704178196915432005-08-10T15:01:00.000-05:002005-08-10T15:02:58.206-05:00Replication Optimization TipsAvoid publishing unnecessary data.Try to restrict the amount of published data. This can results in good performance benefits, because SQL Server will publish only the amount of data required. This can reduce network traffic and boost the overall replication performance. Article from MS SQL City, moreUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1123548842022876672005-08-08T19:47:00.000-05:002005-08-08T19:54:24.863-05:00Decrypt Stored ProcedureThis SP will decrypt Stored Procedures, Views or Triggers that were encrypted using "with encryption" There are 2 versions: one for SP's only and the other one for SP's, triggers and views version 1: INPUT: object name (stored procedure, view or trigger) version 2: INPUT: object name (stored procedure, view or trigger), object type('T'-trigger, 'P'-stored procedure or 'V'-view). Code by Joseph Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-13752993.post-1123388431142988552005-08-06T23:17:00.000-05:002005-08-06T23:20:31.150-05:00SQL Server MaintenanceA database maintenance plan is implemented using a series of DBCC commands and system stored procedures. DBCC stands for database consistency check or database console command. There are numerous documented and undocumented DBCC commands, but only a few of them are used for maintenance. A typical database maintenance schedule involves the following activities. 1. Check database consistency andUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1123189087592143682005-08-04T15:56:00.000-05:002005-08-06T18:35:04.213-05:00UDF Part IIAll UDFs are defined using the CREATE FUNCTION statement, which varies slightly for scalar, in-line, and multi-statement functions. Scalar UDFs have the following syntax:CREATE FUNCTION owner.function_name (parameter_name data_type [=default] [, n])RETURNS scalar_data_type[WITH function_option]AS BEGINFunction_bodyRETURN scalar_expressionENDArticle by Baya Pavliashvili, moreRecommended Book:Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-13752993.post-1123078261268490252005-08-03T09:09:00.000-05:002005-08-03T09:12:46.226-05:00UDFs in SQL ServerUser-defined functions (UDF) allow you to add custom solutions for unique application-specific problems. Tasks can be as simple as calculating a value or as complex as defining and implementing table constraints. Technically speaking, SQL Server UDFs are subroutines of encapsulated Transact-SQL (T-SQL) logic that you can call into action via other T-SQL code to return a scalar (single) value or aUnknownnoreply@blogger.com0