This month's T-SQL Tuesday is hosted by Bradly Ball (blog | twitter) and the topic is second chances. The idea is to pick one of those moments in our career we wish we could do once again. A second chance to make it all better, or at least to make us sleep a little better at night. So here goes... Almost 6 years ago I left the university with a fresh degree in my pocket but of course with no actual knowledge of how the world turns.
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
Because of a job change next week I have no need for Oracle anymore, I decided to remove it. I know that some people complain that uninstalling SQL Server is a pain, well those people should just be quiet from now on, uninstalling Oracle is much worse. In order to uninstall Oracle, you need to run the Oracle Universal Installer. Once you run it, click on the Deinstall Products button
I have a listbox on a form that gets some data from a service that is slow, I mean a whole 500ms slow. That is unacceptable. The data is not very critical so I can load it in the background. This easy. vbnet Private Sub LoadList(ByVal id as Integer) Task.Run(Sub() 'Do something slow RaiseEvent TellTheUIWheAreReadyAndThatItHasNewData(ByVal newList as IList(Of CoolThing)) End Sub) End Sub The UI will update when the Task has run.
On Monday the 3 monthly password change happened and the account I use for testing this application also had it’s password changed. Oh joy. This is an app that uses windows authentication but my test server has an identity impersonate to make sure it always uses the same account. Which is not the account I use to develop on my machine. Anyway. I noticed that the password was wrong because of this.
Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI solutions, Microsoft has changed its name a few times. You know, to make it less confusing. Here's a nice overview: BIDS or Business Intelligence Development Studio. The most non-confusing name of the bunch. This piece of software was delivered to you when you installed SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2.
With almost all databases running on SQL Server, at some point there will be a need to load data, move data or delete data from tables that are not ideally setup for the operations in large batch sizes. While many methods exist to handle the actual task of any of these needs, a commonly overlooked side effect of performing large batch operations is, transaction log growth. For over a decade now, one of the most commonly answered questions on the community forums and all around is, “My transaction log grew out of control and I need to reclaim my disk space.
I was asked the other day, “Is there really a difference in performance loading data into newer versions of SQL Server in the same process?“ The question really has many variables that need to be answered prior to even considering an answer. Such variables are the data architecture, I/O setup for each, loading method such as bulk loading, SQL database and SQL Server Instance configurations, pipe and network latency, and on.
Last week my colleague Valentino and I did a session on Data Visualisation Tips & Tricks at the Belgian Community Day. At the beginning of the session there were only a handful of people in the room but luckily we quickly realized the keynote was running over time. So after the keynote speaker finally wrapped up his talk, our audience steadily grow to about 60 people which exceeded our expectations. Valentino's demos didn't fail, I didn't fall of the stage and I heard good feedback, so we're safe to say our session was a bit of a success.
Visual Studio 2013 Preview, Visual Studio 2012 Update 3 and .NET Framework 4.5.1 are available for download You can download the following versions of Visual Studio 2013 Preview Visual Studio 2013 Preview Visual Studio Ultimate 2013 Preview Visual Studio Premium 2013 Preview Visual Studio Professional 2013 Preview Visual Studio Test Professional 2013 Preview Team Foundation Server 2013 Preview Visual Studio Express 2013 Preview Visual Studio Express 2013 Preview for Web
If you want to try out Windows 8.1 preview right now, you can. Be aware that when you install Windows 8.1 preview that you will have to reinstall all your apps. If you then upgrade to the final RTM version you will have to do this again. Going from Windows 8 to Windows 8.1 RTM does not have this reinstall requirement nonsense You can download Windows 8.1 preview here http://windows.microsoft.com/en-us/windows-8/download-preview