To make sure I do not miss any of them I keep looking for SAP documentation, SAP notes, blogs on SCN and the SAP on SQL Server section of MSDN before I start with a new migration. For the system databases (Master, Model, and MSDB), I recommend daily backups.Under Frequency, for Occurs: select Daily.Under Daily frequency, for Occurs once at: set an appropriate time (e.g
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Note that this map-to keyword is a) always interpreted as a single word, and b) is both case and space sensitive! In our sample, "ms windows" query will not match the document with "MS Windows" text
Facebook Microsoft OLE DB provider for SQL Server error 80004005 BY Mahesh Gupta on August 10, 2012 0 comments While browsing a ASP site, you end up getting SQL Server error 80004005. Thus by End of 1st year, our database size is expected to be 13 GB (1 Gb initial and 1 GB per month) After a year company is expected to come up with big launch and will advertise in market and expected 5 time growth in second year i.e
Discover what Cortana Analytics can do for your data Bring your data to life and spot trends with Microsoft Power BI Power BI transforms your company's data into rich visuals so you can focus on what matters to you
12 Essential Steps After Installing SQL Server - SQL Server Performance
Similarly, if your server is going to execute Integration Service packages, ensure the SSIS service starts automatically every time the server boots up. Unless you want to have your Windows Administrators to have access to the SQL Server, you should get rid of this group from the sysadmin fixed server role
SQL server has always lagged behind on the general developer's Visual Studio and .NET versions to work with and that's understandable; but I do feel support for the new Office file formats has arrived just a SQL Server release too late. In the meantime, the client changed requirements to have zipped delimited text files instead of xlsx so I no longer had to worry about getting them zipped xlsx files
SQL Server Replication - SQL Server Performance
Ideally, the distribution component of replication should be on its own dedicated server, not located on the server running the publishing or subscribing components of replication. If you need maximum performance for your transactional or merge replication, you should place the log of every database you want replicated on it own separate disk array
Microsoft SQL Server Development Customer Advisory Team Maximizing Throughput with TVP Posted over 2 years ago by AzureCAT 3 Comments As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. Microsoft SQL Server Development Customer Advisory Team Diagnosing Transaction Log Performance Issues and Limits of the Log Manager Posted over 2 years ago by AzureCAT 4 Comments As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content
Is there a query to retrieve the partition ranges? In my example I am expecting to see the list of current partition ranges like Jan2011, Feb2011 Thanks. USE TestDB; GO --- Step 6 : Insert Data in Partitioned Table INSERT INTO TestTable (ID, Date) -- Inserted in Partition 1 VALUES (1,GETDATE()); INSERT INTO TestTable (ID, Date) -- Inserted in Partition 2 VALUES (11,GETDATE()); INSERT INTO TestTable (ID, Date) -- Inserted in Partition 2 VALUES (12,GETDATE()); GO Step 7 : Test Data from TestTable Query TestTable and see the values inserted in TestTable
Second, the minimum and maximum memory amounts are important, especially since we gave the SQL Server account the permission to lock its pages in memory. John writes: I also like to go to model and change the recovery model from FULL since we use SIMPLE a lot, even in production and also change the datafile autogrowth setting from 1 MB
ORACLE : STAGE1 : SERVER STAGE2: ONLY 1 DATABASE STAGE3: MORE THAN ONE SCHEMA IN DATABASE If you execute any script at serve level, because there is only one database, it can give you results. Help please as I am trying to set up the connection to the dbase where the user will only be able to see a select set of tables, views and with either userid pass word via ms sql mang console or ODBC have just select access to tables for users, keeping things locked down from the user
Get SQL Server log shipping functionality without Enterprise Edition
As the DBA, you should make a recommendation based on your knowledge of the database, but senior management should ultimately decide how much data loss is acceptable. Unlike SQL Server clustering -- which has an Active node and a Passive node -- log shipping requires two active nodes, meaning both hosts must be licensed
SQLServerCentral.com
951 5,296 2 days ago @ 12:38 AM In: RE: Virtual server By Blackdog Employers and Employees Opinions and questions about interactions with employees and employers. 58 731 Wednesday, April 8, 2015 4:39 AM In: RE: Movie Rental Database By Grant Fritchey Hardware Discussions about SQL Server hardware and sizing your servers
Essentially, this security concern played a role in helping define Windows authentication as the recommended practice for managing authentication in the past. This setting, which is regularly referred to as mixed mode authentication, uses either Active Directory user accounts or SQL Server accounts when validating access to SQL Server
Faster insights on any data Get to insights faster with a complete BI platform that speeds up how you access, analyze, clean and shape both internal and external data. Back to top SQL Server 2014 in the news Gartner Read Gartner's Magic Quadrant for Advanced Analytics Platforms Read the story Gartner Read Gartner's Magic Quadrant for Business Intelligence and Analytics Platforms Read the story Gartner Read Gartner's Magic Quadrant for Data Warehouse and Data Management Solutions for Analytics 2015 Read the story TechRadar.pro Microsoft SQL Server 2014 review: The database heads into memory for Microsoft's latest release Read the review Back to top SQL Server blog Announcing Spark for Azure HDInsight public preview 10 Jul 2015 04:10 PM by T.K
SQL Server 2005 log shipping setup using the wizard
This allows read-only access and users will not be able to make any changes to the database (i.e., create indexes) and they will be disconnected when the next database backup is applied. No transaction log backups have been done on the primary database since the backup was done, or if they have been done, they have been restored on the secondary
No comments:
Post a Comment