In the last tutorial in this series of Reporting Services tutorials we added conditional formatting to the report. Now that we have created our first report and have added a bit of flare to it, we will go ahead and make it even cleaner. In this very quick demonstration, we will go ahead and change the visibility of rows or columns based on given conditions.
We've been working on it over the years, trying to get some search engine that works. Well, we're trying a new one from Surfinity. Give it a try and let us know how it works. Read on for a few details about what we're using.
Once again it's taken longer than expected, but it's out! The second version in print and PDF of the best articles from 2003. Read about it and pick up a copy to support the site.
How many times do you need to estimate space for a new application? Or estimate growth for an existing one? We've had a new contribution to the freeware section of the site. Tablesizer will allow you to guesstimate how much disk space you'll need. Take a peek if you need it, rate the product and give the author any feedback you have.
Books on line has been updated since the release of SQL2000.
If you check the documentation for the sp_addlogin stored procedure and example E says
SELECT CONVERT(VARBINARY(32), password) then you should update your installation.
SQL Server showplan is a great tool for analyzing queries and determining whether or not more performance tuning needs to be done. However working with showplan can be confusing and it takes some practice to learn the ins and outs of what is occurring. Joseph Sack looks at showplan and seven of the main things that he is aware of when looking at the results. If you've rarely or never used showplan, this is a great article to get started in learning how an experienced DBA views the output.
In T-SQL you should use the IS NULL keywords to test for a null value. But David Poole runs into a strange gotcha in one of his applications where he is testing for a null value. It's an interesting read following Sherlock Poole around on his hunt to find an error.
SQL Server DTS is an amazing ETL tool. Parallel processing is not only possible, but author Leo Peysakhovich shows us how he does it in this article about his index rebuild process. By bundling DTS into SQL Server for free, Microsoft gave us a platform for not only ETL, but also many basic tasks that all DBAs are stuck working on. Read on to see if parallel processing of index rebuilds is something you can use.
Storing passwords in SQL Server for authentication by your application is a common practice. But not always a good one. Someone with access could easily see all passwords and perhaps cause mischief inside your application. Imagine the office gossip getting access to your HR application as the HR director! Not a good thing. Dinesh Asanka has written a short piece on how you can use a built in function in SQL Server to encrypt these passwords and use them with a minimum of effort.
Andy discusses one of the questions he uses to screen senior developer candidates. While the question itself is interesting, we think it will be more interesting to see how many of you agree with one of his positions - that developers think of program code and sql code as different animals, especially when it comes to debugging.
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers