corpus.blog
56,966 blogs · [ { "id": "01a0d1d3-35cf-71f9-92ed-02edb5e46d1a", "title": "New built-in function TRIM() in SQL Server 2017", "url": "https://sqlwithmanoj.com/2016/12/26/new-built-in-function-trim-in-sql-server-vnext-2018/", "published_at": "2016-12-26T01:30:10+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edb5ea0dc9", "title": "SQL Error – SQL Server blocked access to STATEMENT ‘OpenRowset/ OpenDatasource’ of component ‘Ad Hoc Distributed Queries’", "url": "https://sqlwithmanoj.com/2016/12/25/sql-error-sql-server-blocked-access-to-statement-openrowset-opendatasource-of-component-ad-hoc-distributed-queries/", "published_at": "2016-12-25T01:30:07+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edb685324a", "title": "SQL Error – The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)", "url": "https://sqlwithmanoj.com/2016/12/24/sql-error-the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine-system-data/", "published_at": "2016-12-24T08:47:15+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edb749a159", "title": "New built-in function STRING_AGG() with option “WITHIN GROUP” – SQL Server 2017", "url": "https://sqlwithmanoj.com/2016/12/23/new-function-string_agg-with-option-within-group-sql-server-vnext-2018/", "published_at": "2016-12-23T01:30:38+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edb75104e1", "title": "SQL DBA – Quickly Clone a Database in SQL Server (2016 SP1 & 2014 SP2) with DBCC CLONEDATABASE command", "url": "https://sqlwithmanoj.com/2016/12/22/quickly-clone-a-database-in-sql-server-2016-sp1-2014-sp2-with-dbcc-clonedatabase-command/", "published_at": "2016-12-22T01:30:40+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edb8181b0c", "title": "SQL Basics – AGGREGATE Functions in SQL Server", "url": "https://sqlwithmanoj.com/2016/12/21/sql-basics-aggregate-functions-in-sql-server/", "published_at": "2016-12-21T01:30:03+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edb841d025", "title": "SQL Error – SQL Server service failed to Start | Windows could not start the SQL Server", "url": "https://sqlwithmanoj.com/2016/12/15/sql-error-sql-server-service-failed-to-start-windows-could-not-start-the-sql-server/", "published_at": "2016-12-15T01:30:22+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edb8b0cdc1", "title": "Microsoft released SQL Server vNext (2017) – New features and enhancements in CTP 1.x", "url": "https://sqlwithmanoj.com/2016/11/20/microsoft-released-sql-server-vnext-2018-new-features-and-enhancements-in-ctp-1-0/", "published_at": "2016-11-20T01:30:22+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edb8fac466", "title": "Now “CREATE OR ALTER” Stored Procedure, Function, View, Trigger with SQL Server 2016", "url": "https://sqlwithmanoj.com/2016/11/19/now-create-or-alter-stored-procedure-function-view-trigger-with-sql-server-2016/", "published_at": "2016-11-19T01:30:33+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edb95dd49d", "title": "SQL Server 2016 1st Service Pack (SP1) is out (download, new features & enhancements)", "url": "https://sqlwithmanoj.com/2016/11/17/sql-server-2016-1st-service-pack-sp1-is-out-download-new-features-enhancements/", "published_at": "2016-11-17T01:30:39+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edb9d45166", "title": "SQL Error – Unable to open the physical file. Operating system error 5: “5(Access is denied.)”", "url": "https://sqlwithmanoj.com/2016/10/25/sql-error-unable-to-open-the-physical-file-operating-system-error-5-5access-is-denied/", "published_at": "2016-10-25T01:30:39+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edba25309c", "title": "Get SSRS Report Stats, Usage report and Runtime", "url": "https://sqlwithmanoj.com/2016/10/12/get-ssrs-report-stats-usage-report-and-runtime/", "published_at": "2016-10-12T11:15:15+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edba660787", "title": "Windows Service stuck at “Starting” status", "url": "https://sqlwithmanoj.com/2016/09/14/windows-service-stuck-at-starting-status/", "published_at": "2016-09-14T09:43:00+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edbb187a9c", "title": "SQL Trivia – Multiple ways to get list of all tables in a database", "url": "https://sqlwithmanoj.com/2016/08/22/sql-trivia-multiple-ways-to-get-list-of-all-tables-in-a-database/", "published_at": "2016-08-22T01:30:35+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edbb6ccb78", "title": "SQL Error – SHOWPLAN permission denied in database", "url": "https://sqlwithmanoj.com/2016/08/10/sql-error-showplan-permission-denied-in-database/", "published_at": "2016-08-10T10:50:29+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edbc3c4b40", "title": "SQL Trivia – What all schemas cannot be dropped in a SQL Server database?", "url": "https://sqlwithmanoj.com/2016/08/04/sql-trivia-what-all-schemas-cannot-be-dropped-in-a-sql-server-database/", "published_at": "2016-08-04T01:30:29+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edbd31a9da", "title": "SQL Error – Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option", "url": "https://sqlwithmanoj.com/2016/07/20/sql-error-error-severity-levels-greater-than-18-can-only-be-specified-by-members-of-the-sysadmin-role-using-the-with-log-option/", "published_at": "2016-07-20T01:30:53+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edbd89ba1b", "title": "Using some best practices for SQL Server in Azure VM (IaaS) to get MAX performance", "url": "https://sqlwithmanoj.com/2016/06/30/using-some-best-practices-for-sql-server-in-azure-vm-iaas-to-get-max-performance/", "published_at": "2016-06-30T01:30:02+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edbe6c3b42", "title": "SQL Error – Windows could not start the SQL Server (MSSQLSERVER) on Local Computer (moved Master DB)", "url": "https://sqlwithmanoj.com/2016/06/29/sql-error-windows-could-not-start-the-sql-server-mssqlserver-on-local-computer-moved-master-db/", "published_at": "2016-06-29T01:30:38+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edbe8c50f5", "title": "SQL DBA – Move master Database to another drive – in simple steps", "url": "https://sqlwithmanoj.com/2016/06/28/dba-move-master-database-to-another-drive-in-simple-steps/", "published_at": "2016-06-28T01:30:35+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edbf0dea72", "title": "SQL Error – The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE", "url": "https://sqlwithmanoj.com/2016/06/22/sql-error-the-server-may-be-running-out-of-resources-or-the-assembly-may-not-be-trusted-with-permission_set-external_access-or-unsafe/", "published_at": "2016-06-22T01:30:08+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edbf1519fc", "title": "SQL Error – SSMS, ‘-120’ is not a valid value for property ‘Width’ or ‘Height’", "url": "https://sqlwithmanoj.com/2016/06/17/sql-error-ssms-120-is-not-a-valid-value-for-property-width-or-height/", "published_at": "2016-06-17T01:30:50+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc00cee77", "title": "New Sample database “WideWorldImporters” for SQL Server 2016 and Azure SQL Database", "url": "https://sqlwithmanoj.com/2016/06/11/new-sample-database-wideworldimporters-for-sql-server-2016-and-azure-sql-database/", "published_at": "2016-06-11T01:30:53+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc0656e9b", "title": "Polybase error in SQL Server 2016 : Row size exceeds the defined Maximum DMS row size, larger than the limit of [32768 bytes]", "url": "https://sqlwithmanoj.com/2016/06/09/polybase-error-in-sql-server-2016-row-size-exceeds-the-defined-maximum-dms-row-size-larger-than-the-limit-of-32768-bytes/", "published_at": "2016-06-09T01:30:49+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc0dc1e89", "title": "SQL Server 2016 RTM full and final version available – Download it now !!!", "url": "https://sqlwithmanoj.com/2016/06/01/sql-server-2016-full-and-final-version-available-download-it-now/", "published_at": "2016-06-01T18:01:49+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc1a0bc2e", "title": "Microsoft PSS – SQL 2016 Series: It just runs faster | May updates", "url": "https://sqlwithmanoj.com/2016/05/31/microsoft-pss-sql-2016-series-it-just-runs-faster-may-updates/", "published_at": "2016-05-31T01:30:53+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc1f3fb26", "title": "SQL Server CROSS APPLY and OUTER APPLY usage – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2016/05/29/sql-server-cross-apply-and-outer-apply-usage-msdn-tsql-forum/", "published_at": "2016-05-29T15:16:25+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc23fb2dc", "title": "SQL Server 2012: Error handling for multiple errors – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2016/05/28/sql-server-2012-error-handling-for-multiple-errors-msdn-tsql-forum/", "published_at": "2016-05-28T15:03:58+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc318e4b5", "title": "How resolve error OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)” returned message “Unspecified error – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2016/05/14/how-resolve-error-ole-db-provider-microsoft-ace-oledb-12-0-for-linked-server-null-returned-message-unspecified-error-msdn-tsql-forum/", "published_at": "2016-05-14T14:59:05+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc39f22e2", "title": "What is external tables for in SQL Server 2016 ? – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2016/05/01/what-is-external-tables-for-in-sql-server-2016-msdn-tsql-forum/", "published_at": "2016-05-01T14:41:25+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc3c7d7fe", "title": "Microsoft PSS – SQL 2016 Series: It just runs faster | April updates", "url": "https://sqlwithmanoj.com/2016/04/30/microsoft-pss-sql-2016-series-it-just-runs-faster-april-updates/", "published_at": "2016-04-30T12:38:15+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc49afb63", "title": "Informatica – The first character in a name cannot be a number (error)", "url": "https://sqlwithmanoj.com/2016/04/13/informatica-the-first-character-in-a-name-cannot-be-a-number-error/", "published_at": "2016-04-13T01:30:16+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc4b828a3", "title": "DB Basics – How to control Data Redundancy in a database system (RDBMS) by Normalization", "url": "https://sqlwithmanoj.com/2016/04/12/db-basics-how-to-control-data-redundancy-in-a-database-system-rdbms-by-normalization/", "published_at": "2016-04-12T01:30:57+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc51b30e5", "title": "Download & Install SQL Server Management Studio (SSMS) 2016 (decoupled from SQL Server engine setup)", "url": "https://sqlwithmanoj.com/2016/04/06/download-install-sql-server-management-studio-ssms-2016-decoupled-from-sql-server-engine-setup/", "published_at": "2016-04-06T14:42:40+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc5ea1c84", "title": "Good news – Microsoft makes SQL Server “Developer Edition” free for developers !", "url": "https://sqlwithmanoj.com/2016/04/01/good-news-microsoft-makes-sql-server-developer-edition-free-for-developers/", "published_at": "2016-04-01T01:30:57+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc625a740", "title": "SQL Trivia – What are Niladic functions in SQL Server?", "url": "https://sqlwithmanoj.com/2016/03/30/sql-trivia-what-are-niladic-functions-in-sql-server/", "published_at": "2016-03-30T01:30:40+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc722e450", "title": "Microsoft PSS – SQL 2016 Series: It just runs faster | Feb-March updates", "url": "https://sqlwithmanoj.com/2016/03/28/sql-2016-series-it-just-runs-faster-feb-march-updates/", "published_at": "2016-03-28T01:30:38+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc76e1406", "title": "Custom Query to check Frequency, Interval and Time of multiple Job’s in SQL Server", "url": "https://sqlwithmanoj.com/2016/03/22/custom-query-to-check-frequency-interval-and-time-of-multiple-jobs-in-sql-server/", "published_at": "2016-03-22T01:30:46+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc7d22509", "title": "Using system SPs to get details of SQL Jobs, Steps, Commands, Schedule, Last run details, etc", "url": "https://sqlwithmanoj.com/2016/03/21/using-system-sps-to-get-details-of-sql-jobs-steps-commands-schedule-last-run-details-etc/", "published_at": "2016-03-21T01:30:34+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc7e138f3", "title": "View Dependencies of a Table from SSMS and T-SQL script used internally by SSMS", "url": "https://sqlwithmanoj.com/2016/03/17/view-dependencies-of-a-table-from-ssms-and-t-sql-script-used-internally-by-ssms/", "published_at": "2016-03-17T01:30:56+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc8027652", "title": "My whitepaper published on – Top 8 features of SQL Server 2016", "url": "https://sqlwithmanoj.com/2016/03/14/my-whitepaper-published-on-top-8-features-of-sql-server-2016/", "published_at": "2016-03-14T01:30:47+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc8c7f876", "title": "SQL Server on Linux – Microsoft announcement", "url": "https://sqlwithmanoj.com/2016/03/12/sql-server-on-linux-microsoft-announcement/", "published_at": "2016-03-12T01:30:32+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edc9596260", "title": "New in-built Table-Valued Function STRING_SPLIT() in SQL Server 2016 – to split strings", "url": "https://sqlwithmanoj.com/2016/03/10/new-in-built-table-valued-function-string_split-in-sql-server-2016-to-split-strings/", "published_at": "2016-03-10T01:30:49+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edca54ab68", "title": "“SELECT *” or “SELECT 1” or “SELECT column_Name” while using EXISTS() – what shoud I use? – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2016/03/09/select-or-select-1-or-select-column_name-while-using-exists-what-shoud-i-use-msdn-tsql-forum/", "published_at": "2016-03-09T01:30:25+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edcaf5de73", "title": "SQL Server 2016 RC0, first Release Candidate is available for download", "url": "https://sqlwithmanoj.com/2016/03/08/sql-server-2016-rc0-first-release-candidate-is-available-for-download/", "published_at": "2016-03-08T01:30:07+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edcbade2f5", "title": "A very Happy SQL-licious & SQL-s-tastic Valentines day to all of you !!!", "url": "https://sqlwithmanoj.com/2016/02/14/a-very-happy-sql-licious-sql-s-tastic-valentines-day-to-all-of-you/", "published_at": "2016-02-14T07:10:51+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edccab7146", "title": "SQL Server 2016 CTP 3.3 update is here | download now", "url": "https://sqlwithmanoj.com/2016/02/05/sql-server-2016-ctp-3-3-update-is-here-download-now/", "published_at": "2016-02-05T01:30:27+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edcd8ff5a8", "title": "Informatica – WRT_8229, Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.", "url": "https://sqlwithmanoj.com/2016/01/27/informatica-wrt_8229-multiple-step-ole-db-operation-generated-errors-check-each-ole-db-status-value-if-available-no-work-was-done/", "published_at": "2016-01-27T01:30:45+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edce72c3d6", "title": "Informatica – There is no Integration Service found for this workflow (error)", "url": "https://sqlwithmanoj.com/2016/01/25/informatica-there-is-no-integration-service-found-for-this-workflow-error/", "published_at": "2016-01-25T12:27:39+00:00" }, { "id": "01a0d1d3-35cf-71f9-92ed-02edcf180f5f", "title": "How to import/store photos with file name and other properties into SQL Server table – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2016/01/22/how-to-importstore-photos-with-file-name-and-other-properties-into-sql-server-table-msdn-tsql-forum/", "published_at": "2016-01-22T01:30:11+00:00" }, { "id": "01a0d1d3-7894-72e9-b7d9-1eff6234280e", "title": "Parse or Query XML column with XMLNAMESPACES (xmlns namespace) – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2016/01/15/parse-or-query-xml-column-with-xmlnamespaces-xmlns-namespace-msdn-tsql-forum/", "published_at": "2016-01-15T01:30:30+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e192339a7a42", "title": "SQL Trivia – Difference between COUNT(*) and COUNT(1)", "url": "https://sqlwithmanoj.com/2016/01/13/sql-trivia-difference-between-count-and-count1/", "published_at": "2016-01-13T01:30:23+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19234032677", "title": "SQL Error – The database owner SID recorded in the master database differs from the database owner SID", "url": "https://sqlwithmanoj.com/2016/01/09/sql-error-the-database-owner-sid-recorded-in-the-master-database-differs-from-the-database-owner-sid/", "published_at": "2016-01-09T01:30:50+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19234c465e8", "title": "Implementing “Row Level Security” (RLS) with “Block Predicates” in SQL Server 2016 – Part 2", "url": "https://sqlwithmanoj.com/2016/01/09/implementing-row-level-security-rls-with-block-predicates-in-sql-server-2016-part-2/", "published_at": "2016-01-09T01:30:45+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19234dde287", "title": "2015 in review", "url": "https://sqlwithmanoj.com/2015/12/30/2015-in-review/", "published_at": "2015-12-30T04:35:56+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923542b61d", "title": "SQL Server 2016 CTP 3.2 update is here | download now", "url": "https://sqlwithmanoj.com/2015/12/18/sql-server-2016-ctp-3-2-update-is-here-download-now/", "published_at": "2015-12-18T01:30:15+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19235e2c65b", "title": "Exam 70-461, SQL 2014 update – Querying Microsoft SQL Server 2014", "url": "https://sqlwithmanoj.com/2015/12/01/exam-70-461-sql-2014-update-querying-microsoft-sql-server-2014/", "published_at": "2015-12-01T15:22:22+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19236884e8b", "title": "SQL Server 2016 CTP 3.1 update is here | download now", "url": "https://sqlwithmanoj.com/2015/12/01/sql-server-2016-ctp-3-1-update-is-here-download-now/", "published_at": "2015-12-01T09:49:17+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19236bd803a", "title": "SQL DBA – Database restored successfully, but stuck in (Restoring…) state", "url": "https://sqlwithmanoj.com/2015/11/27/sql-dba-database-restored-successfully-but-stuck-in-restoring-state/", "published_at": "2015-11-27T16:16:13+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e192376dcbdd", "title": "New syntax option “IF EXISTS” with DROP and ALTER statements – in SQL Server 2016", "url": "https://sqlwithmanoj.com/2015/11/03/new-syntax-option-if-exists-with-drop-and-alter-statements-in-sql-server-2016/", "published_at": "2015-11-03T01:30:48+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e192377866d9", "title": "Store JSON data in a table, OPENJSON and JSON_Value functions | SQL Server 2016 – Part 4", "url": "https://sqlwithmanoj.com/2015/11/02/store-json-data-in-a-table-openjson-and-json_value-functions-sql-server-2016-part-4/", "published_at": "2015-11-02T01:30:00+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19237f99c81", "title": "Reading JSON string with Nested array of elements | SQL Server 2016 – Part 3", "url": "https://sqlwithmanoj.com/2015/11/01/reading-json-string-with-nested-elements-sql-server-2016-part-3/", "published_at": "2015-11-01T01:30:43+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19238f3fec3", "title": "Passing multiple/dynamic values to Stored Procedures & Functions | Part 5 – by passing JSON string", "url": "https://sqlwithmanoj.com/2015/10/31/passing-multipledynamic-values-to-stored-procedures-functions-part-5-by-passing-json-string/", "published_at": "2015-10-31T01:30:54+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19239d40d1c", "title": "Import/Read a JSON string and convert it in tabular (row/column) form | SQL Server 2016 – Part 2", "url": "https://sqlwithmanoj.com/2015/10/30/importread-a-json-string-and-convert-it-in-tabular-rowcolumn-form-sql-server-2016-part-2/", "published_at": "2015-10-30T01:30:14+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19239f21972", "title": "SQL Server 2016 CTP 3 update is here | download now", "url": "https://sqlwithmanoj.com/2015/10/29/sql-server-2016-ctp-3-update-is-here-download-now/", "published_at": "2015-10-29T01:30:00+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923a03a2a2", "title": "Code Review checklist for SQL Server “Stored Procedures” & T-SQL Scripts", "url": "https://sqlwithmanoj.com/2015/10/25/code-review-checklist-for-sql-server-stored-procedures-t-sql-scripts/", "published_at": "2015-10-25T13:33:26+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923a90bc11", "title": "Store file data to SQL without streaming on server – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/10/14/store-file-data-to-sql-without-streaming-on-server-msdn-tsql-forum/", "published_at": "2015-10-14T09:26:28+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923b47c123", "title": "SQL Tips – Check count of records in Temporary Tables from other sessions", "url": "https://sqlwithmanoj.com/2015/10/13/sql-tips-check-count-of-records-in-temporary-tables-from-other-sessions/", "published_at": "2015-10-13T08:57:45+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923c1d2163", "title": "SQL Error – The database principal owns a schema in the database, and cannot be dropped", "url": "https://sqlwithmanoj.com/2015/10/10/sql-error-the-database-principal-owns-a-schema-in-the-database-and-cannot-be-dropped/", "published_at": "2015-10-10T01:30:27+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923ce6fd99", "title": "SQL Error – Cannot create index on view ‘vw_SomeView’ because the view is not schema bound.", "url": "https://sqlwithmanoj.com/2015/10/05/sql-error-cannot-create-index-on-view-vw_someview-because-the-view-is-not-schema-bound/", "published_at": "2015-10-05T03:53:44+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923d9d130b", "title": "SQL Server 2016 CTP 2.4 update is here | download now", "url": "https://sqlwithmanoj.com/2015/10/01/sql-server-2016-ctp-2-4-update-is-here-download-now/", "published_at": "2015-10-01T07:48:01+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923da36873", "title": "SQL Basics – Data Types in SQL Server (Video)", "url": "https://sqlwithmanoj.com/2015/09/20/sql-basics-data-types-in-sql-server-video/", "published_at": "2015-09-20T17:45:36+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923dc4c405", "title": "DB Basics – As Primary Key can identify a row uniquely, what are the scenarios you need a Super Key?", "url": "https://sqlwithmanoj.com/2015/09/17/db-basics-as-primary-key-can-identify-a-row-uniquely-what-are-the-scenarios-you-need-a-super-key/", "published_at": "2015-09-17T01:30:00+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923e27b213", "title": "Stretch your on-premise Database/Table to Azure SQL Database with StretchDB – SQL Server 2016", "url": "https://sqlwithmanoj.com/2015/09/15/stretch-you-on-premise-databasetable-to-azure-sql-database-with-stretchdb-sql-server-2016/", "published_at": "2015-09-15T01:30:00+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923e8147f0", "title": "SQL Server Geeks Annual Conference sessions – SSGAS 2015", "url": "https://sqlwithmanoj.com/2015/09/04/sql-server-geeks-annual-conference-sessions-ssgas-2015/", "published_at": "2015-09-04T07:35:31+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923eb92bae", "title": "SQL Server 2016 CTP 2.3 update available | download now", "url": "https://sqlwithmanoj.com/2015/09/04/sql-server-2016-ctp-2-3-update-available-download-now/", "published_at": "2015-09-04T01:30:00+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923f0668f9", "title": "What does “on-disk structure” means w.r.t Indexes in SQL Server – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/08/18/what-does-on-disk-structure-means-w-r-t-indexes-in-sql-server-msdn-tsql-forum/", "published_at": "2015-08-18T09:56:57+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1923f8f6f97", "title": "SQL Error – Unable to generate a temporary class (result=1), error CVT1108, error CS1583", "url": "https://sqlwithmanoj.com/2015/08/14/sql-error-unable-to-generate-a-temporary-class-result1-error-cvt1108-error-cs1583/", "published_at": "2015-08-14T13:18:33+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1924009d738", "title": "How exactly STATIC CURSOR works internally – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/08/12/how-exactly-static-cursor-works-internally-msdn-tsql-forum/", "published_at": "2015-08-12T09:50:53+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e192406692bc", "title": "Difference between Index and Primary Key – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/08/10/difference-between-index-and-primary-key-msdn-tsql-forum/", "published_at": "2015-08-10T09:36:34+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e192415c04db", "title": "Informatica – ERROR: Workflow [FOLDER_NAME:WORKFLOW_NAME[version 1]] is disabled. Please check the Integration Service log for more information.", "url": "https://sqlwithmanoj.com/2015/08/10/informatica-error-workflow-folder_nameworkflow_nameversion-1-is-disabled-please-check-the-integration-service-log-for-more-information/", "published_at": "2015-08-10T01:30:41+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19241afcf49", "title": "Resolving issues while enabling Temporal Data on an existing Table", "url": "https://sqlwithmanoj.com/2015/08/07/resolving-issues-while-enabling-temporal-data-on-an-existing-table/", "published_at": "2015-08-07T01:30:41+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19241b15b27", "title": "Error Msg 8672, MERGE statement attempted to UPDATE or DELETE the same row more than once – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/08/05/error-msg-8672-merge-statement-attempted-to-update-or-delete-the-same-row-more-than-once-msdn-tsql-forum/", "published_at": "2015-08-05T10:03:50+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1924202110d", "title": "Memory Optimized “Table Variables” in SQL Server 2014 and 2016", "url": "https://sqlwithmanoj.com/2015/07/31/memory-optimized-table-variables-in-sql-server-2014-and-2016/", "published_at": "2015-07-31T01:30:00+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1924267dbbf", "title": "Obfuscate column level data by using “Dynamic Data Masking” in SQL Server 2016", "url": "https://sqlwithmanoj.com/2015/07/20/obfuscate-column-level-data-by-using-dynamic-data-masking-in-sql-server-2016/", "published_at": "2015-07-20T01:30:32+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e192433a3083", "title": "SQL Basics – What are System databases | master, model, msdb, tempdb, resource", "url": "https://sqlwithmanoj.com/2015/07/17/sql-basics-what-are-system-databases-master-model-msdb-tempdb-resource/", "published_at": "2015-07-17T01:30:00+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1924432c908", "title": "SQL DBA – Configure multiple TempDB Database Files while installing SQL Server 2016 (new feature)", "url": "https://sqlwithmanoj.com/2015/07/15/configure-multiple-tempdb-database-files-while-installing-sql-server-2016-new-feature/", "published_at": "2015-07-15T01:30:49+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19245017886", "title": "Implementing “Row Level Security” (RLS) with “Filter Predicate” in SQL Server 2016 – Part 1", "url": "https://sqlwithmanoj.com/2015/07/13/implementing-row-level-security-rls-with-sql-server-2016/", "published_at": "2015-07-13T01:30:00+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19245e8b8ee", "title": "Pass an array of multiple values with a single Parameter in a Stored Procedure – SQL Server", "url": "https://sqlwithmanoj.com/2015/07/10/passing-multiple-values-with-a-single-parameter-in-a-stored-procedure-sql-server/", "published_at": "2015-07-10T12:38:49+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e192466fabf4", "title": "Bug with ISNUMERIC() – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/07/08/bug-with-isnumeric-msdn-tsql-forum/", "published_at": "2015-07-08T13:54:09+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19246d56ce1", "title": "SQL Error – Execution of user code in the .NET Framework is disabled. Enable “clr enabled” configuration option", "url": "https://sqlwithmanoj.com/2015/06/26/sql-error-execution-of-user-code-in-the-net-framework-is-disabled-enable-clr-enabled-configuration-option/", "published_at": "2015-06-26T12:01:21+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19247461199", "title": "SQL Error – SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’", "url": "https://sqlwithmanoj.com/2015/06/25/sql-error-sql-server-blocked-access-to-procedure-dbo-sp_send_dbmail-of-component-database-mail-xps/", "published_at": "2015-06-25T11:43:15+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e192476ee241", "title": "new CTP 2.1 update for SQL Server 2016 available for download", "url": "https://sqlwithmanoj.com/2015/06/25/new-ctp-2-1-update-for-sql-server-2016-available-for-download/", "published_at": "2015-06-25T05:28:17+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e192485ded7e", "title": "SQL Error – SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component ‘xp_cmdshell’", "url": "https://sqlwithmanoj.com/2015/06/24/sql-error-sql-server-blocked-access-to-procedure-sys-xp_cmdshell-of-component-xp_cmdshell/", "published_at": "2015-06-24T11:33:35+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19248b38c03", "title": "Using GO statement within a Stored Procedure – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/06/19/using-go-statement-within-a-stored-procedure-msdn-tsql-forum/", "published_at": "2015-06-19T10:10:37+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19249427739", "title": "Time Travel with Temporal Tables in SQL Server 2016 – Part 2", "url": "https://sqlwithmanoj.com/2015/06/17/time-travel-with-temporal-tables-in-sql-server-2016-part-2/", "published_at": "2015-06-17T01:30:00+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e19249d27280", "title": "SQL Tip – How to get size of all Tables in a Database?", "url": "https://sqlwithmanoj.com/2015/06/16/sql-tip-how-to-get-size-of-all-tables-in-a-database/", "published_at": "2015-06-16T09:04:20+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1924a28a32f", "title": "SQL Error – The operation cannot be performed on a database with database snapshots or active DBCC replicas", "url": "https://sqlwithmanoj.com/2015/06/16/sql-error-the-operation-cannot-be-performed-on-a-database-with-database-snapshots-or-active-dbcc-replicas/", "published_at": "2015-06-16T06:43:20+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1924afecdf4", "title": "SQL Database Recovery tool to repair corrupt MDF file", "url": "https://sqlwithmanoj.com/2015/06/16/sql-database-recovery-tool-to-repair-corrupt-mdf-file/", "published_at": "2015-06-16T01:30:00+00:00" }, { "id": "01a0d1d3-7895-70d4-a592-e1924b85557f", "title": "Temporal data support in SQL Server 2016 – Part 1", "url": "https://sqlwithmanoj.com/2015/06/15/temporal-data-support-in-sql-server-2016-part-1/", "published_at": "2015-06-15T01:30:00+00:00" } ] posts Claim your blog
Back to sqlwithmanoj.com
Blog · corpus.blog/blogs/sqlwithmanoj.com/posts

sqlwithmanoj.com

sqlwithmanoj.com

2016

New built-in function TRIM() in SQL Server 2017original ↗
26 Dec 2016
SQL Error – SQL Server blocked access to STATEMENT ‘OpenRowset/ OpenDatasource’ of component ‘Ad Hoc Distributed Queries’original ↗
25 Dec 2016
SQL Error – The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)original ↗
24 Dec 2016
New built-in function STRING_AGG() with option “WITHIN GROUP” – SQL Server 2017original ↗
23 Dec 2016
SQL DBA – Quickly Clone a Database in SQL Server (2016 SP1 & 2014 SP2) with DBCC CLONEDATABASE commandoriginal ↗
22 Dec 2016
SQL Basics – AGGREGATE Functions in SQL Serveroriginal ↗
21 Dec 2016
SQL Error – SQL Server service failed to Start | Windows could not start the SQL Serveroriginal ↗
15 Dec 2016
Microsoft released SQL Server vNext (2017) – New features and enhancements in CTP 1.xoriginal ↗
20 Nov 2016
Now “CREATE OR ALTER” Stored Procedure, Function, View, Trigger with SQL Server 2016original ↗
19 Nov 2016
SQL Server 2016 1st Service Pack (SP1) is out (download, new features & enhancements)original ↗
17 Nov 2016
SQL Error – Unable to open the physical file. Operating system error 5: “5(Access is denied.)”original ↗
25 Oct 2016
Get SSRS Report Stats, Usage report and Runtimeoriginal ↗
12 Oct 2016
Windows Service stuck at “Starting” statusoriginal ↗
14 Sept 2016
SQL Trivia – Multiple ways to get list of all tables in a databaseoriginal ↗
22 Aug 2016
SQL Error – SHOWPLAN permission denied in databaseoriginal ↗
10 Aug 2016
SQL Trivia – What all schemas cannot be dropped in a SQL Server database?original ↗
4 Aug 2016
SQL Error – Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG optionoriginal ↗
20 Jul 2016
Using some best practices for SQL Server in Azure VM (IaaS) to get MAX performanceoriginal ↗
30 Jun 2016
SQL Error – Windows could not start the SQL Server (MSSQLSERVER) on Local Computer (moved Master DB)original ↗
29 Jun 2016
SQL DBA – Move master Database to another drive – in simple stepsoriginal ↗
28 Jun 2016
SQL Error – The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFEoriginal ↗
22 Jun 2016
SQL Error – SSMS, ‘-120’ is not a valid value for property ‘Width’ or ‘Height’original ↗
17 Jun 2016
New Sample database “WideWorldImporters” for SQL Server 2016 and Azure SQL Databaseoriginal ↗
11 Jun 2016
Polybase error in SQL Server 2016 : Row size exceeds the defined Maximum DMS row size, larger than the limit of [32768 bytes]original ↗
9 Jun 2016
SQL Server 2016 RTM full and final version available – Download it now !!!original ↗
1 Jun 2016
Microsoft PSS – SQL 2016 Series: It just runs faster | May updatesoriginal ↗
31 May 2016
SQL Server CROSS APPLY and OUTER APPLY usage – MSDN TSQL forumoriginal ↗
29 May 2016
SQL Server 2012: Error handling for multiple errors – MSDN TSQL forumoriginal ↗
28 May 2016
How resolve error OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)” returned message “Unspecified error – MSDN TSQL forumoriginal ↗
14 May 2016
What is external tables for in SQL Server 2016 ? – MSDN TSQL forumoriginal ↗
1 May 2016
Microsoft PSS – SQL 2016 Series: It just runs faster | April updatesoriginal ↗
30 Apr 2016
Informatica – The first character in a name cannot be a number (error)original ↗
13 Apr 2016
DB Basics – How to control Data Redundancy in a database system (RDBMS) by Normalizationoriginal ↗
12 Apr 2016
Download & Install SQL Server Management Studio (SSMS) 2016 (decoupled from SQL Server engine setup)original ↗
6 Apr 2016
Good news – Microsoft makes SQL Server “Developer Edition” free for developers !original ↗
1 Apr 2016
SQL Trivia – What are Niladic functions in SQL Server?original ↗
30 Mar 2016
Microsoft PSS – SQL 2016 Series: It just runs faster | Feb-March updatesoriginal ↗
28 Mar 2016
Custom Query to check Frequency, Interval and Time of multiple Job’s in SQL Serveroriginal ↗
22 Mar 2016
Using system SPs to get details of SQL Jobs, Steps, Commands, Schedule, Last run details, etcoriginal ↗
21 Mar 2016
View Dependencies of a Table from SSMS and T-SQL script used internally by SSMSoriginal ↗
17 Mar 2016
My whitepaper published on – Top 8 features of SQL Server 2016original ↗
14 Mar 2016
SQL Server on Linux – Microsoft announcementoriginal ↗
12 Mar 2016
New in-built Table-Valued Function STRING_SPLIT() in SQL Server 2016 – to split stringsoriginal ↗
10 Mar 2016
“SELECT *” or “SELECT 1” or “SELECT column_Name” while using EXISTS() – what shoud I use? – MSDN TSQL forumoriginal ↗
9 Mar 2016
SQL Server 2016 RC0, first Release Candidate is available for downloadoriginal ↗
8 Mar 2016
A very Happy SQL-licious & SQL-s-tastic Valentines day to all of you !!!original ↗
14 Feb 2016
SQL Server 2016 CTP 3.3 update is here | download noworiginal ↗
5 Feb 2016
Informatica – WRT_8229, Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.original ↗
27 Jan 2016
Informatica – There is no Integration Service found for this workflow (error)original ↗
25 Jan 2016
How to import/store photos with file name and other properties into SQL Server table – MSDN TSQL forumoriginal ↗
22 Jan 2016
Parse or Query XML column with XMLNAMESPACES (xmlns namespace) – MSDN TSQL forumoriginal ↗
15 Jan 2016
SQL Trivia – Difference between COUNT(*) and COUNT(1)original ↗
13 Jan 2016
SQL Error – The database owner SID recorded in the master database differs from the database owner SIDoriginal ↗
9 Jan 2016
Implementing “Row Level Security” (RLS) with “Block Predicates” in SQL Server 2016 – Part 2original ↗
9 Jan 2016

2015

2015 in revieworiginal ↗
30 Dec 2015
SQL Server 2016 CTP 3.2 update is here | download noworiginal ↗
18 Dec 2015
Exam 70-461, SQL 2014 update – Querying Microsoft SQL Server 2014original ↗
1 Dec 2015
SQL Server 2016 CTP 3.1 update is here | download noworiginal ↗
1 Dec 2015
SQL DBA – Database restored successfully, but stuck in (Restoring…) stateoriginal ↗
27 Nov 2015
New syntax option “IF EXISTS” with DROP and ALTER statements – in SQL Server 2016original ↗
3 Nov 2015
Store JSON data in a table, OPENJSON and JSON_Value functions | SQL Server 2016 – Part 4original ↗
2 Nov 2015
Reading JSON string with Nested array of elements | SQL Server 2016 – Part 3original ↗
1 Nov 2015
Passing multiple/dynamic values to Stored Procedures & Functions | Part 5 – by passing JSON stringoriginal ↗
31 Oct 2015
Import/Read a JSON string and convert it in tabular (row/column) form | SQL Server 2016 – Part 2original ↗
30 Oct 2015
SQL Server 2016 CTP 3 update is here | download noworiginal ↗
29 Oct 2015
Code Review checklist for SQL Server “Stored Procedures” & T-SQL Scriptsoriginal ↗
25 Oct 2015
Store file data to SQL without streaming on server – MSDN TSQL forumoriginal ↗
14 Oct 2015
SQL Tips – Check count of records in Temporary Tables from other sessionsoriginal ↗
13 Oct 2015
SQL Error – The database principal owns a schema in the database, and cannot be droppedoriginal ↗
10 Oct 2015
SQL Error – Cannot create index on view ‘vw_SomeView’ because the view is not schema bound.original ↗
5 Oct 2015
SQL Server 2016 CTP 2.4 update is here | download noworiginal ↗
1 Oct 2015
SQL Basics – Data Types in SQL Server (Video)original ↗
20 Sept 2015
DB Basics – As Primary Key can identify a row uniquely, what are the scenarios you need a Super Key?original ↗
17 Sept 2015
Stretch your on-premise Database/Table to Azure SQL Database with StretchDB – SQL Server 2016original ↗
15 Sept 2015
SQL Server Geeks Annual Conference sessions – SSGAS 2015original ↗
4 Sept 2015
SQL Server 2016 CTP 2.3 update available | download noworiginal ↗
4 Sept 2015
What does “on-disk structure” means w.r.t Indexes in SQL Server – MSDN TSQL forumoriginal ↗
18 Aug 2015
SQL Error – Unable to generate a temporary class (result=1), error CVT1108, error CS1583original ↗
14 Aug 2015
How exactly STATIC CURSOR works internally – MSDN TSQL forumoriginal ↗
12 Aug 2015
Difference between Index and Primary Key – MSDN TSQL forumoriginal ↗
10 Aug 2015
Informatica – ERROR: Workflow [FOLDER_NAME:WORKFLOW_NAME[version 1]] is disabled. Please check the Integration Service log for more information.original ↗
10 Aug 2015
Resolving issues while enabling Temporal Data on an existing Tableoriginal ↗
7 Aug 2015
Error Msg 8672, MERGE statement attempted to UPDATE or DELETE the same row more than once – MSDN TSQL forumoriginal ↗
5 Aug 2015
Memory Optimized “Table Variables” in SQL Server 2014 and 2016original ↗
31 Jul 2015
Obfuscate column level data by using “Dynamic Data Masking” in SQL Server 2016original ↗
20 Jul 2015
SQL Basics – What are System databases | master, model, msdb, tempdb, resourceoriginal ↗
17 Jul 2015
SQL DBA – Configure multiple TempDB Database Files while installing SQL Server 2016 (new feature)original ↗
15 Jul 2015
Implementing “Row Level Security” (RLS) with “Filter Predicate” in SQL Server 2016 – Part 1original ↗
13 Jul 2015
Pass an array of multiple values with a single Parameter in a Stored Procedure – SQL Serveroriginal ↗
10 Jul 2015
Bug with ISNUMERIC() – MSDN TSQL forumoriginal ↗
8 Jul 2015
SQL Error – Execution of user code in the .NET Framework is disabled. Enable “clr enabled” configuration optionoriginal ↗
26 Jun 2015
SQL Error – SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’original ↗
25 Jun 2015
new CTP 2.1 update for SQL Server 2016 available for downloadoriginal ↗
25 Jun 2015
SQL Error – SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component ‘xp_cmdshell’original ↗
24 Jun 2015
Using GO statement within a Stored Procedure – MSDN TSQL forumoriginal ↗
19 Jun 2015
Time Travel with Temporal Tables in SQL Server 2016 – Part 2original ↗
17 Jun 2015
SQL Tip – How to get size of all Tables in a Database?original ↗
16 Jun 2015
SQL Error – The operation cannot be performed on a database with database snapshots or active DBCC replicasoriginal ↗
16 Jun 2015
SQL Database Recovery tool to repair corrupt MDF fileoriginal ↗
16 Jun 2015
Temporal data support in SQL Server 2016 – Part 1original ↗
15 Jun 2015
Previous Next