The open source Barcode Image Generation Library enables insertion of twenty-seven different types of linear barcode symbols into SSRS reports without the use of barcode fonts.
2018-11-12
8,360 reads
SQL Server 2012 supports SHA-256 and SHA-512 through the HASHBYTES() function, but earlier versions of SQL Server do not. SHA-256, SHA-384 and SHA-512 can, however, be implemented in SQL Server 2005 or SQL Server 2008 with the CLR assembly described in this article.
2013-10-07
5,527 reads
How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.
2015-08-21 (first published: 2013-05-08)
28,103 reads
Learn how to simplify deployment and maintenance of SQL CLR assemblies by using T-SQL instead of Visual Studio.
2013-05-07
9,082 reads
Hello,I am not sure where I can find anything about grouping by number. To be more specific :Table: 2 columnsNumber of the week Amount 1 502 253 474 155 56 877 268 1059 6710 18 Now I need to get SUM() for every 3 weeks or 6 weeks or any number I need. Can not find how to […]
2005-05-05
Your arguement is certainly valid, but there are some very good reasons to abstract your middle tier from your database. First one that jumps out is how poorly TSQL organizes logic. Since TSQL isn't an object based language, encapsulation and reuse make building a good business layer difficult. This does change with CLR in the […]
2005-05-02
As you've probably already found out, there are a lot of different ways to do things in ASP and ADO. Somethings to consider when choosing which way to do it is the possibility of SQL injection attacks as well as performance. Using a parameterized ADO Command Object reduces the risk of SQL injection attacks (note: […]
2004-02-25
Frank, it took a year and a half..but I won that battle...almost fired because of it too. Bad DBA wanting secure database not good when only DBA with 10 developers. I was outmanned on the battlefield.There is a fine art to doing things right and not denting any egos. Definitely worth a white paper
2004-02-25
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-02-25
The user does not have backup permission on our production database. He just uses a development database to do his work and we are not concerned if he breaks anything there. I just wanted to verify what I had thought about the With NO_LOG option.I also don't understand why the transaction log is filling up […]
2004-02-18
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers