The Multi-Tennant capability of Oracle 12c has been available for some time now. This technology is really cool, and to my knowledge, not available in any other SQL database engine. At a high level, how this works is you create a Container database in Oracle 12c. Once the container is created you can add separate database instances of the same […]

John shares with us a few queries he uses, and would like to pass on to our readers. John writes: Concerning your scripts for creating a comma separated list from a single field: This is what I do to perform the same functionality. It is a bit more robust I think since I am also formatting the data a bit, […]

Let me start out by saying I came across the following syntax while reading a forum on building dynamic SQL. I can’t find the address right now; but I would like to share the syntax letting you know it is not unique to me. I love SQL that uses a variable to build something based on a set of data […]

Most Information Technology professionals agree that you use the best tools to get the job done. Sometimes the tools you need are already believable from open source or commercial packages. Many times you can deploy a pre-developed package implementing it with your own configuration. For example, Sales Force is a popular CRM package you can purchase; or you could use […]

This is one of my favorite topics when it comes to writing SQL Queries because it utilizes my favorite data dimension, time. A rolling window is a virtual window of time from a specific starting point. You can have a rolling window of years, quarters, months, days, hours, minutes, seconds. You get the point. So, in order to have a […]

There is an incredible, and growing, amount of data available to you through the SSWUG site. Sometimes you may find it difficult to find content you know exists. I thought I would share a couple tips that helped me find some content for a reader today. First enter your search terms in the “Search SSWUG ORG” text box on the […]

Ed Writes: In a different slant on cross-database operations, we are looking for the best ways to split a database into two where some of the stored procedures use tables from both databases and there is the need for referential integrity with tables in the other database. The reason we would do this? To split the application configuration away from […]

Microsoft ships a TableDiff utility along with SQL Server. This utility compares the contents of two tables, and outputs the results of the comparison in different ways depending on settings past by the client. Tablediff can be used as part of your replication strategy confirming success or failure. The tablediff utility does have some restrictions. It only works with SQL […]

Many DBAs modify System databases created by the data engine provider in order to host objects that are not specific to a single database. For example, I wrote a stored procedure that retrieves all running processes returning the database, SQL, and other properties of the command that was or is being executed. For Microsoft SQL Server I came up with […]

Yesterday I talked about using the Windows Core 2012 Server edition of windows as a host operating system for Hyper-V enabled virtual machines as SQL Server hosts. The Intel hardware now provides excellent performance running with this kind of configuration; so performance is no longer as much of a factor against virtual machines as in days of old. Ok, just […]