In one of SQL Server Central’s recent daily newsletters, Steve Jones’s editorial was inquiring whether or not anyone has been using the CLR (common language runtime) integration within SQL Server. Recently, a change in a business process dictated that we needed to delete over 3 billion rows from a 16 billion row table – not […]
If you work in IT, the office becomes your second home. It’s where we make a living, and most of us take a lot of pride in the work we do. We feel good when we’ve put in a successful day at the office, however we also have those days where instead of feeling successful, […]
I’m just a little late to the party, but no time like the present, right? I plan to be very active responding to #sqlhelp requests, and will be posting my latest blog posts. I would greatly appreciate a follow (@AdamKreul), and would be happy to return the favor!
That guy or gal over there going on and on about spindles and IOPS – that’s your SAN admin. For the sake of your SQL Server environment, you two need to develop a solid relationship. Here’s some basic SAN lingo to get you started: LUN LUN is an acronym for Logical Unit Number. Each volume […]
If you administer a SQL Server Reporting Services server, chances are you’ve had users complain the report manager is loading slow. You go out the report manager to investigate, and it loads normally. You have the end user try again, and this time it works fine for them too. You think about it for a […]
I recently read Microsoft’s research paper on Hekaton, the new in-memory database engine in SQL Server 2014. When I first heard about it, I was pretty excited, but after reading the deep dive specs, I’m ecstatic. I highly recommend checking out the research paper in its entirety, but for those who prefer a faster read, […]