(Michael K. Campbell) As humans (and especially as IT professionals), we’re wired towards optimization and the need to refine. Or, as Antoine de Saint Exupéry said in The Little Prince, "It seems that perfection is attained not when there is nothing more to add, but when there is nothing more to rem
Tag: sql server
Help : How to find cause of ‘Login failed for user’ error
(blakhani) “Login failed for user” is one of the most common error which everyone might have seen at least once. In this blog, I am going to share few possible causes of the error and their solution. First, we need to understand that due to security reasons, SQL Server doesn’t send more information
SQL Server Reporting Services Models Available on AppSense Exchange
(Gary McAllister) I’m delighted to say that two SQL Server Reporting Services (SSRS) models have been made available for download on AppSense Exchange.
SQL Server Reporting Services Report and Group Variable References
(Scott Murray) How can report group variables be referenced in SQL Server Reporting Services (SSRS) and in what way are they used? Are there any limitations with Report and Group variables in SSRS? Can you show me an example of using these SSRS variables? When would you use SQL Server Reporting S
SQL SERVER – SSMS: Configuration Changes History
(Pinal Dave) As we go through each of the reports available in SQL Server Management Studio, I have an anecdote to share almost for most of them actually. I have used them extensively at different times and I am glad to share some of them via this blog series.
Help!!! My Dynamics GP SQL Server is out of disk space!!!
(Steve Endow) ZOMG! Your SQL Server only has 8 MEGABYTES of disk space left!!! What do you do???
When Will Key SQL Server Processes End?
(Tim Ford) I grew up in the age of FM radio; back when there were still human disk jockeys and vinyl records. These disk jockeys had a very open secret when it come to long songs: long songs = freedom.
ASP.NET Session State using SQL Server In-Memory
(Ken Kilty) Since the earliest days of “classic” ASP through present day ASP.NET 4.5 Web Forms many developers have leveraged a feature called ASP.NET Session State as a means to persist short lived per user data. This feature allows the developer to store and retrieve values for individual users a
db_ddladmin and the SSMS table designer
(Kenneth Fisher) If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you have a several options. For example:
VM Snapshots and Performance or: How I Learned to Love My Martian Data Center
(Thomas LaRock) It takes a radio signal just about 1.28 seconds to get to the Moon (about 239,000 miles away), and about 2.5 seconds for round trip communication between our secret moon base and Earth. So, therefore this common SQL Server error message number 833…
