[Update 2018] Please visit Snippet’s Generator page for the latest release of the tool and much more. Our software tool “Snippets Generator” just got new features with its brand new release v2.1! Snippets Generator allows the user to easily create T-SQL snippets for use in SQL Server 2012 SSMS or later! In this new release, the … Read more…
In this article, we will be discussing about massively detaching and re-attaching databases in SQL Server. Why massively detaching and re-attaching all the databases in a SQL Server instance? There are cases where you might need to massively detach and re-attach all the databases in a SQL Server instance. Such scenario can be a … Read more…
The SELECT ALL USER SECURABLES permission in SQL Server 2014 is a very useful new server-level permission. The login that gets granted this permission, can view the data in all databases that the user can connect to. For example, consider a scenario where you have the following three databases: db1 db2 db3 Each database has … Read more…
This post, is actually a T-SQL tip, on how to easily insert leading characters to a string. The Scenario for Inserting Leading Characters Consider that you have a fixed-length table column for which you want to add leading characters, so that all its records, values with the same number of characters. How to Insert Leading … Read more…
Earlier this month, on the 22nd, another Cyprus .NET User Group event took place. The event featured two hourly topics dedicated to the Microsoft Cloud and its services. The first topic was on Windows Azure for Developers and the second on Windows Azure SQL Database, formerly SQL Azure. The event was also live streamed and … Read more…
Do you like “walking on clouds”? Heard of Azure but not quite sure what it is and what its capabilities are? Join us at CDNUG on Wednesday May 22 2013 and learn more about Windows Azure and its services offered for the developer! Code on premises, deploy on the cloud and many more are the … Read more…
We live in a Data World. I cannot tell you whether this is a good or a bad thing but I can tell you for sure that this is a fact. Everything works based on data. In the enterprise, this data needs to be stored into powerful, scalable and robust data platforms (Relational Database Management … Read more…
April 1st: Waiting for the magic email. For the email which says that my MVP status is renewed for another year and so the journey continues. A journey into the amazing world of the Microsoft MVP Award Program, connected directly to the source of one of the world’s greatest technologies: SQL Server! In the afternoon … Read more…
Welcome to another screencast of the “SQL Server 2012 Screencast Series“! In this short screencast we talk about code snippets in SQL Server 2012 Management Studio. Code Snippets are being used for many years now by developers in Integrated Development Environments (IDEs) like Microsoft Visual Studio. Their benefits vary. Some of them are: Code Reuse … Read more…
In this article, we will be discussing about the different available options, for encrypting SQL Server databases. The Need for Data Encryption In corporate environments there is always the requirement/policy of data protection. Data is the most valuable asset in every organization, after its human resources of course, as it is with data where … Read more…
—— Retrieves Security-Related Information— for all the SQL Server Logins—— SQL Server versions supported: SQL Server 2005 or later—SELECT [name] as LoginName,LOGINPROPERTY ([name] , ‘DefaultDatabase’) as DefaultDatabase,LOGINPROPERTY ([name] , ‘DaysUntilExpiration’) as DaysUntilExpiration,(CASE ISNULL(LOGINPROPERTY ([name] , ‘IsExpired’),0) WHEN 0 THEN ‘False’ ELSE ‘True’ END) as IsExpired,(CASE ISNULL(LOGINPROPERTY ([name] , ‘IsLocked’),0) WHEN 0 THEN ‘False’ ELSE ‘True’ END) … Read more…
[Update 2018] Please visit Snippet’s Generator page for the latest release of the tool and much more. We are very happy to announce the general availability of version 2.0 of Snippets Generator. Snippets Generator allows the user to easily create T-SQL snippets for SQL Server 2012 and later! You can create a snippet from scratch or … Read more…
Hello friends, Another year has come to an end and as being faithful to the “tradition” of posting in the last day of every year my selected tweets for the year that ends, here I am, posting the “Selected Tweets of Year 2012!“. It was another great year of interaction with you, the SQL Server Community. … Read more…
Via this post, you can watch an interesting screencast, about Migrating to a Contained Database in SQL Server 2012 or later. Introduction: What are Contained Databases in SQL Server? Contained Databases is an exciting new feature, originally shipped with SQL Server 2012. Among other, it introduces a more robust security model where you can … Read more…
Yeah, I know, who would ever want to do that (!) but the purpose of this post is not to illustrate how you can actually get all the records from all tables in all user databases (even though it shows how to do it) but rather to provide an example of how we can dynamically … Read more…