(K. Brian Kelley) I have audited for permissions on my databases because users seem to be accessing the tables, but I don’t see permissions which give them such rights. I’ve gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the user
Other News
Special Fireside Version: SelecTViews – SQL Server 2011 upcoming features, SQL Server tip, recent news and more.
Video Programming for IT Professionals
Generating XForms Using XQuery
(Kurt Cagle) Okay, I’ll admit it – there are times that even I hate writing things in XML. The structured syntax, the angle brackets, even the sheer verbosity of the language can be tedious at best, and downright mind-numbing at worst. I suspect that one of the reasons that programmers prefer to use
The internal storage of a DATETIMEOFFSET value
(Peter) Today I went for investigating the internal storage of DATETIME2 datatype. What I found out was that for a datetime2 value with precision 0 (seconds only), SQL Server need 6 bytes to represent the value, but stores 7 bytes.
Update on ASP.NET MVC 3 RC2 (and a workaround for a bug in it)
(Scott Guthrie) Last week we published the RC2 build of ASP.NET MVC 3. I blogged a bunch of details about it here.
DB2 SQL Skin Customer Interview: BJC Healthcare, Sybase ASE to DB2 Migration
(Rav Ahuja) This is an interview with Tom Holdener, Senior Technical Specialist at BJC Healthcare and an early user of the IBM DB2 SQL Skin solution.
Getting all selected rows in ADF Table with multiple rows selection enabled
(Arun) When we build a web application which contains an ADF Table (with multiselect option), in many cases, we require to get all the selected rows to process through backing bean. This example will illustrate how to achieve that.
How well does your table fits in innodb buffer pool ?
(Peter Zaitsev) Understanding how well your tables and indexes fit to buffer pool are often very helpful to understand why some queries are IO bound and others not – it may be because the tables and indexes they are accessing are not in cache, for example being washed away by other queries.
Server Side Paging
Server Side Paging A new feature being released (sadly, one of the very few TSQL Enhancements) in SQL Server Denali is the ability to do server side paging. You have a web page allowing you to display a limited amount of rows. It calls a database query that may produce many more times the number of rows presented. This is […]
SQL Server command-line utilities: sqlcmd
(Ray Rankins, Paul T. Bertucci, Chris Gallelli and Alex T. Silverstein) SQL Server command-line utilities give database administrators a new way to access the database engine and its components. In this three-part series from the book “Microsoft SQL Server 2008 R2 Unleashed,” we’ll review each utili