Category: Microsoft SQL Server

Feed: Mr. Fox SQL. For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney… SQL Saturday 769 (Sat 30 Jun 2018) Melbourne.  SQL Saturday 771 (Sat 07 Jul 2017) Sydney.  For those looking for some great free local SQL / Azure / BI / etc learning, you simply cannot go past a SQL Saturday anywhere in the world!  And this one right here in Melbourne will again be no exception.  There is a lineup of fantastic local speakers including Microsoft and MVP’s as well as international speakers too. SQL Saturday Pre-Con Training (Fri 29 Jun 2018).  Melbourne.   Leading ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . By Gregory A. Larsen In my last tip Displaying the Object Explorer Details Pane in SQL Server Management Studio, you learned how to bring up the Object Explorer Details pane. In this tip, you’ll see how to use the “Filter” item in the Object Explorer Details window, to show a specific list of tables that contain a specific string of characters. In order to use the filter item, first bring up the Object Explorer Details pane for the tables in the WideWorldImportersDW database. I do this by selecting the “Tables” item under ... Read More

Feed: James Serra's Blog. Author: James Serra. The Common Data Model (CDM) is a shared data model that is a place to keep all common data to be shared between applications and data sources.  Another way to think of it is is a way to organize data from many sources that are in different formats into a standard structure. The Common Data Model includes over 340 standardized, extensible data schemas that Microsoft and its partners have published.  This collection of predefined schemas includes entities, attributes, semantic metadata, and relationships.  The schemas represent commonly used concepts and activities, such as Account and Campaign, ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . By Gregory A. Larsen You are probably familiar with the Object Explorer pane in SQL Server Management Studio (SSMS), and how to bring it up. But, are you familiar with the Object Explorer Details pane and how to display it? If not, then read on. The Object Explorer Detail pane shows detailed information about an object that you have selected in Object Explorer. The information displayed depends on the object you have selected in the Object Explorer. You can open the Object Explorer Details pane two different ways.  The first way to ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Data development in a pure open source environment is possible. In larger enterprises and consulting firms, expect to interface with internal and external systems based on a mix of open source, homegrown code, and commercial technologies. Thousands of words could be devoted to pontificating on the ideal of pure environments. That is not this article. Open source database tools are found in many categories, including engine, modeling, script management, metadata, interactive query, semantic layer development, governance and more. TEAM ENVIRONMENT Open source database management tools are proper for professional developers. Is it ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Have you ever heard of the identity cache? If not, it is just a cache that stores the next 1000 available identity cached values for a table. The identity cache was introduced in SQL Server 2012 and is used to improve the performance of generating new identify values. The problem with this cache is, if SQL Server should abort or be shutdown unexpectedly, SQL Server loses track of the values in the identity cache. When this occurs, SQL Server gets another set of 1000 identity values, and you end up with gaps ... Read More

Feed: Puppet Blog Feed. Author: William Hurt; Hello and welcome to this blog post all about using the new Bolt tasks in the Puppet module for Microsoft SQL Server. If you're not familiar with Puppet Bolt, it's our new multi-platform task automation application that lets you run one-off tasks against multiple machines at the same time, and makes it easy to share the tasks you're running with the rest of your team. The tasks that we have implemented in the SQL Server module really showcase that ability to share code with your team. Did I mention it's agentless? If you, ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Have you deleted a bunch of rows from a table that has an identity column value? Do you now find that when you insert a new row, you find that the identity column value was set to one higher than the highest identity column value that your table original had? This can happen if you make a mistake and inserted a bunch of rows by accident, and then you delete those accidentally insert rows without reseeding your identity value. If you have made this insert mistake or just delete a bunch of ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . What is the current identity column value in my table? You probably have an identity column defined in some, or a lot of your SQL Server tables.  But do you know how to check the identity value information for one of your tables?  If not, then here is how you do it.   To check the last identity value information for your table you can run the following command: DBCC CHECKIDENT ( 'yourtable', NORESEED ); Where yourtable  is set to the table in which you what to check the identity value information.  ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Cosmos DB constitutes one of the Azure foundational services, which ensures its availability in every existing and newly provisioned Azure region. It delivers a wide range of advantages over traditional SQL and NoSQL-based data stores, including, for example, support for multiple consistency levels, latency and throughput guarantees, policy-based geo-fencing, automatic scaling, and multi-master replication model. However, it also represents significant departure from the traditional database management and development approach that most database administrators are familiar with. In this article, we will review several offerings that you can use at no cost to ... Read More