The model database is a standard database created for every instance of SQL Server, just like Master, MSDB and TempDB. Unlike the other system databases, model is not used frequently. In fact, it is only used when a new database is created. When you create a new database, it clones the model database. So, as you can see, every user […]
Other News
Big Data Ethics and DBAs
Big Data Ethics and DBAs For many, many years we’ve spent time here on SSWUG.org talking about ethics. We even went so far as to create a community-based code of ethics for DBAs. It went repeatedly through many revisions and has "rested" since. (Here’s a link to the finalized look at the statement) Wired just published an interesting article on […]
RDBMS Concept In Normalization & De-normalization of Data — Part 3
RDBMS Concept In Normalization & De-normalization of Data – Part – 3 As stated in the last article that “In the forthcoming article we will be noticing particular fine point’s concerning diverse Normal Forms (3NF and BCNF)”, here is the article. Defining Different Normal Forms:- The Third Normal Form (3NF):- A database table is supposed to be in Third Normal...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
DB2 Performance Tuning Tools
(Craig S. Mullins) Well, as I promised a post or two ago, in this and the next couple of posts we will take a look at database performance tools…
DB2 Tips n Tricks Part 44 – Force User re-prepare query at UOW boundary
(Harishkumar Baburao Pathangay) How to Force User to re-prepare query after execution beyond transactional boundary Solution:
SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be
(Rohit Garg) Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager.
Advanced Options For Loading Data From SQL Server With Power Query
(Chris Webb) Loading data from SQL Server using Power Query is fairly straightforward, and the basics are well-documented (see here for example).
Understanding AngularJS $rootScope and $scope
(Shailendra Chauhan) Scope is an object that refers to the application model. It acts as a context for evaluating expressions. Typically, it acts as a glue between controller and view.
Debugging Tips for JavaScript-based Windows Phone Apps
(Vipul Patel) One of the cool things about the latest version of Visual Studio is that it brings all of its features almost equally to all the platforms it supports. That means, the rich debugging experience that developers have come to love and appreciate for XAML-based Windows and Windows Phone ap
WPF Data Binding – Priority Bindings
(Richard Carr) The one hundredth part of the Windows Presentation Foundation Fundamentals tutorial expands upon data binding with priority bindings. These allow a single binding source to be selected from a number of possible options.