|
|
|
|
|
| | Total Hits: 0 | Today: 0 | Author: Dinesh Asanka | Rating:  |
| | 
Applications typically make connections to the SQL Server databases in large numbers but what if those connections are not successfully closed? How you can monitor them? This short article describes the methods we can use to monitor unclosed connections.... |
| | Total Hits: 0 | Today: 0 | Author: Nipun Tomar | Rating: |
| |
SQL Server Compact Edition (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops. SQL CE targets occasionally-connected applications and applications with an embedded database It includes ADO.NET providers for data access using ADO.NET APIs, and built-in synchronization capabilities, as well as support for LINQ and Entity Framework. SQL CE supports transactions, referential integrity constraints, locking as well as multiple conne... |
| | Total Hits: 0 | Today: 0 | Author: Microsoft Press | Rating: |
| |
Today's competitive economy dictates that organizations reduce cost and improve agility in their database environments. This means the large percentage of organizations out there running underutilized Microsoft SQL Server installations must take control of their environments in order to experience significant cost savings and increased activity. Thankfully, enhancements in hardware and software technologies have unlocked new opportunities to reduce costs through consolidation. Consolidation redu... |
| | Total Hits: 0 | Today: 0 | Author: AlbinAbel | Rating: |
| |
There is no wonder everybody like google search engine and its search box suggestions. An intelligent and friendly search-match suggestion makes it a wonderful user experience. It is very rare we can see a website without a search box. It would be more valuable to discuss something which can improve the search experience.... |
| | Total Hits: 4 | Today: 0 | Author: Brad McGehee | Rating: |
| |
The Microsoft Developer Security Resource Kit is a single resource that provides security-related development guidance. Its contents include best practices, how-to guides, code samples and sample applications, training, and white papers on security topics. This must-have DVD is available free for a limited time — you pay only a small shipping & handling charge. The resource kit is proof that developing more secure applications is easier than you thought, and with this free offer, there is no bet... |
| | Total Hits: 20 | Today: 0 | Author: Susan Sales Harkins | Rating: |
| |
You might expect all SQL Server's clauses to support a column alias. As reasonable as that assumption seems, SQL Server can't honor a column alias in that way. If you refer to an aliased column in another clause, SQL Server returns an error—surprise! Figure 1 shows the result of running such a query; SQL Server can't find the aliased column TotalCost. That's not a bug; SQL Server requires the alias—it has to call the column something!... |
| | Total Hits: 97 | Today: 0 | Author: Tim Ford | Rating: |
| |
I have an internally-developed metadata repository for the SQL Server instances I administer. One of the metrics I track is based upon Job History success and failure. This information comes directly from the msdb..sysjobhistory table that resides upon each SQL Server instance. The issue is that there are idiosyncrasies with this table when it comes to storing dates and times of job executions. I need to be able to use this information in reports and queries, but these columns are stored in ... |
| | Total Hits: 145 | Today: 0 | Author: Andy Novick | Rating: |
| |
A colleague wanted to know a way to make it easy to write stored procedures that reference objects in a different database when the name of the databases might change. For example, when the code is moved into production. He couldn't find a way and neither could I. What could we do about it? Had we missed some feature in SQL Server? Would a feature to help us out ever be part of SQL Server?... |
| | Total Hits: 120 | Today: 0 | Author: Divya Agrawal | Rating: |
| |
One challenge you may be faced with is the need to create running totals for query output, whether it be a straight query or for a report. Doing calculations such as this in Excel are pretty straightforward, because each cell can have a different formula. Are there any T-SQL tricks to help on calculating a running total for a fixed amount of rows?... |
| | Total Hits: 75 | Today: 0 | Author: Ray Barley | Rating: |
| |
We use SSIS to periodically load data into our data warehouse. While much of the data we process is in relational data stores, we do have some Excel spreadsheets that we need to process. In one particular case we load an Excel spreadsheet that is produced by an external application and every month the number of sheets varies and the sheet names are also different. How can we determine the sheet names in our SSIS package and process this variable number of sheets?... |
| | Total Hits: 158 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
I am new to SQL Server and want to learn about the JOIN options. What are all of the JOIN options in SQL Server? What is the significance of each of the options? I am a little confused on the differences and syntax, can you provide some examples and explanations? Are JOINs only for SELECT statements?... |
| | Total Hits: 79 | Today: 0 | Author: Andy Novick | Rating: |
| |
The solution is to create a stored procedure that is implemented in the SQLCLR, which allows writing code in .Net languages and running them within SQL Server. Stored procedures can be written in C#, VB.Net or C++ and the compiler produces an assembly, which is the code compiled into .Net Intermediate Language (IL). The assembly is then loaded into SQL Server and a stored procedure is defined to call one of the static methods in the assembly. When the stored procedure is invoked by a T-SQL EX... |
| | Total Hits: 176 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
With so many security changes in SQL Server 2005, how did the security changes affect SQL Server Agent? I have heard about SQL Server Agent Proxies, but I am not too familiar with them. How do I set them up? What dependencies do they have? What is the security benefit? In SQL Server 2000, a single configuration was available for the SQL Server Agent Proxy account. With SQL Server 2005, now 11 different proxies are available (see #1 below) for each of the SQL Server Agent subsystems.... |
| | Total Hits: 161 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
When it comes time to review server related information from your SQL Server be sure to know how and where to access the information. With SQL Server 2005 some of the resources have changed and new resources have popped up. This tip outlines core server related information from SQL Server 2000 to 2005. Mapping server information between SQL Server 2000 and 2005 is critical to ensure scripts are working properly when upgrading to SQL Server 2005. Below outlines the common server related objects... |
| | Total Hits: 95 | Today: 0 | Author: Joshua Greenberg, Ph.D. | Rating: |
| |
The term rule is often used to describe what may more accurately be called a well-formed formula (wff). In many applications, the satisfaction of a wff is necessary to identify the suitability of some action. For example, in a customer relationship management (CRM) application, we may want to suggest one or more products similar to the product currently being purchased. To make our suggestion as attractive as possible, it would be wise to leverage the information we have gathered about this, and... |
| | Total Hits: 152 | Today: 0 | Author: Jeff Prosise | Rating: |
| |
Now that ASP.NET 2.0 is a shipping product, it seems appropriate to revisit an issue that tops the new features wish lists of many developers: a SQL Server™ site map provider.
As you probably know, ASP.NET 2.0 vastly simplifies the process of building data-driven site navigation interfaces. You build a site map, slap a SiteMapDataSource control onto the page, and bind a Menu or TreeView control to the SiteMapDataSource. The SiteMapDataSource uses the default site map provider (typically XmlSi... |
| | Total Hits: 58 | Today: 0 | Author: Fons Sonnemans | Rating: |
| |
Did you know that any malicious user can corrupt your database by injecting harmful SQL strings? To prevent SQL injection, you can use the parameters collections when building SQL strings. However, I developed a more sophisticated method to construct SQL statements from user's input and execute them safely. In this article I describe how to write and execute SQL statements by using objects instead of SQL strings. These objects also address specific SQL statement syntax issues on different RDBMS:... |
| | Total Hits: 42 | Today: 0 | Author: Alexander Chigrik | Rating: |
| |
In this article, I want to tell you what you should know about trace flags, and how you can use some useful trace flags in SQL Server 6.5 for administering and monitoring.
Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You can set trace flags with DBCC TRACEON command or with the
-T option with the sqlservr command-line executable. After activated, trace flag will be in effect until you restart server, or until you deacti... |
| | Total Hits: 125 | Today: 0 | Author: Marcin Policht | Rating: |
| |
In the previous installments of our series dedicated to SQL Server 2005 Express Edition, we have documented its installation and initial configuration process, as well as described some of its basic features. Based on the information we have presented so far, you might be tempted to conclude that this edition is simply a scaled down rendition of its full-fledged counterparts (such as Standard or Enterprise). However, some of its unique characteristics make it a superior choice under certain circ... |
| | Total Hits: 109 | Today: 0 | Author: whytheluckystiff | Rating: |
| |
I spent last night playing with SQLite and am convinced that this is a tool which could prove incredibly useful to coders and a great tool for learners to check out SQL. The problem is that there isn’t enough documentation for Ruby users who want to take advantage of SQLite’s features.... |
|
|
|
|
|
|
|
|
|
|
|
|
|