Today we will look at a very common debate while developing the data access layer. This is to decide if we want to use stored procedures and keep our logic in the database or do we want to use an ORM like Entity Framework and keep all logic in our middle tier C# code and use the database as a store.
I was surprised on searching desperately not to find a clear answer for what would appear outwardly to be a fairly simple operation in a Microsoft SQL database server.
Alter the column width of a text field from 48 to 60 and retain the primary key.
So here's one for anyone facing similar issue.
With the introduction of AlwaysOn Availability Group (AAG) in SQL Server 2012, log shipping seems to be less widely used than before. AlwaysOn Availability Group provides real-time log shipping as transactions are committed/applied to the primary database server.
After looking into a question at EE, a thought came to my mind that I considered would make a good article. "Transform Text copied from Excel Table into Real Table in SQL" as it is totally possible to do. Here's the result.
This article discusses various scenarios that can end up in a DBCC CHECKDB process getting stuck in a Killed/Rollback state and how to resolve the problem.
This article guides you in finding the user, process and host, which produced too many transactions filling the transaction log and preventing you from shrinking it.
An introduction article to discuss about the various Database states for troubleshooting or health check purposes. More articles will be available in this series to see how to troubleshoot each and every states described in this article.
A clarification of some common doubts about DBCC CHECKDB for Database Administrators. Includes estimated times to repair database corruption's in production databases.
For most Python developers, Microsoft business software is either a great unknown or a necessary evil. Microsoft SharePoint is no exception. Yet, knowing how to integrate Microsoft SharePoint from Python can make all the difference. Plus, it is not that complicated!
This article shows how to force SQL and Web Developers to not use SA account while other services are already deployed to connect to SQL Server via SA account. So we will not touch existing services and applications only developers must be prevented.
In this article, I will be sharing the issues that we faced while converting the data type and NLS semantic to CHAR from BYTES. This was one of the business use cases where we needed to convert the entire columns throughout the schema from BYTES to CHAR types only for VARCHAR2 columns datatypes.
To rank something isn't that difficult. Basically, it is just to sort on the values to rank - points, goals, sales, citizens, whatever - in descending order or (typically for time) ascending order.
But how to rank dupes? Five methods exist, and they can all be implemented in pure SQL or using VBA.
As you can union records, you can join field values. Presented here, DJoin offers increased speed and flexibility compared to the ancient ConcatRelated and similar functions. Further, it offers better read-out of Multi-Value fields.