Generate C# class code for table
For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.
2013-12-24 (first published: 2007-11-06)
12,422 reads
Development
Isolation Levels in SQL Server 2005
Isolation levels are used to prioritize the acccess to a resource. SQL Server 2005 extends upon the support for isolation levels in 2000 with several new features including an additional level.
2007-09-28
4,452 reads
Report Session Caching in Reporting Services 2005
BI Architect Bill Pearson begins a three-part sub-series on Caching Options within Reporting Services 2005. In this article, we focus upon Report Session Caching.
2007-09-05
2,172 reads
Background Images in Reporting Services
Reporting Services makes building rich reports easy, including images and fancy layouts, with a nice wizard. But adding in background images is a little more complex and Andy Warren brings us a quick tutorial for SQL Server 2005's Reporting Services
2007-09-04
12,553 reads
Creating SQL Server Reporting Services templates
Tired of creating templates in SQL Server Reporting Services? Learn how to maintain reusable Reporting Services templates in SQL Server 2005 using BIDS.
2007-08-30
3,809 reads
Building a Partitioned Table
One of the nice new features in SQL Server 2005 is the ability to partition a table based on some sort of range in the data. New author Irfan Baig brings us a short article that explains exactly how you can get started using this new feature.
2007-08-14
8,201 reads
Multi-Select Parameters for Reporting Services
Reporting Services is a very handy way to get your SQL Server 2005 data out to end users quickly. It is included with your license and provides a great development environment for reports. New author Adriaan Davel brings us a quick technique for ensuring that multi-select parameters are handled correctly.
2007-08-13
11,575 reads
The Reporting Services Cribsheet
If you are forced to nod wisely and keep silent when Reporting Services is mentioned, now is the time to turn ignorance into wisdom, with the help of yet another Simple Talk Cribsheet!
2007-08-13
3,540 reads
Table Partitioning
One of the techniques that you can use for increasing performance, especially in large SQL Server tables, is partitioning. Andy Warren brings us an overview of what this is and how you can use it in your SQL Server 2005 applications.
2007-08-09
20,259 reads
Transaction Isolation and the New Snapshot Isolation Level
Concurrency and transaction isolation are a prickly subject, difficult to explain with any kind of clarity without boring the reader and leaving their poor brain in a complete muddle. Therefore, it is often ignored in the vain hope it won't affect us and we can forget all about it. Well you can't ignore it any more and with SQL Server 2005 there's a whole new isolation level added to the four that already exist.
2007-07-19
2,385 reads
Blogs
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
Monday Monitor Tips: Looking Back in Time
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Can You Tell Why a Plan Didn’t Go Parallel?
Let’s face it, most of the time, you probably don’t want your SQL Server...
Forums
Is there a way to determine an Azure Data Factory Trigger's "next run time"?
Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a...
The Table Backup
Comments posted to this topic are about the item The Table Backup
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Question of the Day
The Table Backup
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers