Welcome to Database Weekly

Siemens warns users: Don't change passwords after worm attack The worm uses a default password that, if changed, could crash Siemens' large-scale industrial automation syste read more... Avoiding Accidental Data Leaks In Small Businesses SMBs struggle to educate users, protect company data from unintentional breaches read more... EF Query Tuning Continuing on the topic of application performance tuning, let’s turn our attention specifically to the EF and take a look at some of what’s going on under the covers with EF queries. read more... Did your SQL Agent doze off and you don´t know which jobs to run afterwards ? In some cases you might face the problem that SQL Server Agent Service didn't come up or was stopped for reason. Jobs scheduled in the downtime will not run automatically when the Agent service comes up again, and that is a good thing. I often hear people saying, why isn’t that supposed to be the other way around? Shouldn’t the service revisit the schedules and see which ones he missed and run that ? read more... Secundus Posting (of sorts) It’s been a while since there’s been any new content on here (well, let’s be honest, a very long time). My role at Microsoft has shifted a bit in the last year, going down a slightly different direction and focusing on a new technology area. I shifted over to covering StreamInsight on the SQL Customer Advisory Team, focusing on helping customers and partners with building large scale event driven applications. read more... Getting Organized – 451 Degrees, Good For Notebooks [This is the 4th and final in a series of posts about "Getting Organized" using a better system and the Evernote tool-set for paperless notes (though you could do this with any such software).] read more... Instant File Initialization Speeds SQL Server Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see the end of this posting for a description), I created a new 50GB database. The database creation process took about 5 minutes and 50 seconds to complete. read more... For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed server role could do the following: read more... Syndication on SQLServerCentral I have a few people ask about this recently, so I thought I’d blog about it, and maybe get an explanation out there. read more... T-SQL Snack: Why Does SSMS Generate Create Scripts With EXEC dbo.sp_executesql? Introduction I've been meaning to blog about this for a while and a question from a team member prompted this post (thanks Allan!) SSMS Scripting Options In SSMS you can script a stored procedure - right-click a stored procedure, hover over Script Stored Procedure As, hover over Create To, and select New Query Editor Window: Sometimes the script is generated as shown read more... Recover Backed-up query files in SQL Server Management Studio If SQL Server Management Studio (SSMS) ever crashes on you for whatever reason then there is a chance that you’ll lose whatever queries you had open at the time of the crash. Sometimes when you re-open SSMS it will ask you if you want to re-open any files that you recover but for some reason it doesn’t always do that and in that instance you may think that your work has gone for good. read more... A strategy for managing security for different environments using the Database Development Tools in Visual Studio 2010 Of late I have been getting down and dirty with the Database Development tools in Visual Studio 2010. You may know this feature set by one of the plethora of other names it has had over recent years such as: read more... Viewing how much memory is used by not reused query plan One interesting observation that may help developers get convinced that they should parametrize query and that they must check that the ORM they use does it correctly is show how much memory can be wasted by plans that cannot be effectively reused. read more... 2010 PASS Board Applicants: Douglas McDowell Introduction I am interviewing 2010 PASS Board Nominee Applicants. As listed on the PASS Board Elections site the applicants are: Allen Kinsel Andy Warren Denny Cherry Douglas McDowell Geoff Hiten Jack Corbett Mark Ginnebaugh Markus Sprenger Steve Jones I'm asking everyone the same questions and blogging the responses in the order received. Douglas McDowell is first up: Interview WIth Douglas McDowell read more... SQL University – Indexing Week Welcome back to this week’s installment for SQL University. The topic this time is all about indexing. I know, I know. It sounds incredibly exciting, right? I mean, what could possibly be more exciting than a comprehensive review of a B-tree? Or a lively discussion about having a heap or a clustered index? read more... External Activator Security This short post deals with security and permission-related aspects of External Activat read more... Report Builder 3.0 & Portal Due to popular demand, we are posting the download information for the small stand-alone installer package for Report Builder 3.0 separately as well: http://www.microsoft.com/downloads/details.aspx?FamilyID=d3173a87-7c0d-40cc-a408-3d1a43ae4e33 read more... Thank you for your active community participation… Yes someone is actually listening! It is not often that I blog, as a matter of fact it might even be my first time blogging on the RS team blog. But Robert (Bruckner) and I had felt for a while that we needed to get back to you the community about the impact and importance of your contribution. read more... Reporting Services – Custom Code requests If you’ve been developing complex reports in reporting services then you will likely have resorted to custom code to solve issues like custom aggregations and custom colour palettes. Below are a set of suggestions that relate to developing custom code read more... PivotViewer Extension for Reporting Services – a Cool BI Fusion with Confusing Name Although late to the party, I announce the arrival of a very interesting BI technology - PivotViewer Extension for Reporting Services – CTP1. What's interesting is that it leverages several BI technologies to provide great data visualization: read more...